Notes on postgres database

Postgres.md

1. Create a copy of a database

$ createdb -O <owner> -T database_to_copy new_database

2. Create a database

$ createdb -O <owner> database_name

3. Grant privileges to user on database

$ psql <db_name> -U <user>

# GRANT ALL PRIVILEGES ON DATABASE <db_name> TO <user>;

4. Delete a database

dropdb <dbname>

5. Load database from a backup. Just like the linux pipe

psql <dbname> < infile

6. Create a backup of the database.

pg_dump <dbname> > outfile

Great Article

https://www.codementor.io/engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb