Programming/PostgreSQL/Databases

Note: Unless otherwise specified, all commands from this page assume you're in the PostgreSQL shell.

General Commands

Create a New Database

CREATE DATABASE <database_name>;

Delete a Database

Warn: Note that this action cannot be undone.

DROP DATABASE <database_name>;

Show All Databases

\l

Load a Database

\c <database_name>

Set Database Privileges

GRANT ALL PRIVILEGES ON DATABASE <database_name> TO <user_name>;

Database Backups

Export Database to file

pg_dump -U <user_name> -d <database_name> <file_location>

Import Database from File

pg_restore -U <user_name> -d <database_name> <file_location>