Cheatography
https://cheatography.com
Frequently used commands with PostgreSQL
Connecting to PostgreSQLpsql
| open PostgreSQL interactive terminal | psql -c {command}
| execute a single command and exit | psql -d {dbatabase}
| connect to a particular database | psql -U {role}
| connect as a particular user | psql -l
| list all databases |
Executed from your system command line psql commands\du
| list all roles with their permissions | \l
| list all databases with their owners | \c
| show the current user and the database that you are connected to | \c {database}
| connect to a particular database | \dt
| list all tables in a connected database | \d {table}
| list all columns and indexes for a specific table in a connected database |
Executed inside psql interactive terminal | | Roles and databases managementcreateuser {user}
| create a new PostgreSQL role | dropuser {user}
| drop an existing PostgreSQL role | createdb {database}
| create a new database | dropdb {database}
| drop an existing database |
Executed from your system command line Database backuppg_dump {database} \
> dump.sql
| dump a database to a text file | psql {database} \
< dump.sql
| restore a database from a text file | pg_dump -Ft \
-f dump.tar \
{database}
| dump a database to an archive file | pg_restore -d \
{database} dump.tar
| restore a database from an archive file | pg_dumpall > dump.sql
| dump all databases to a text file |
pg_dump -Ft is the same as --format=tar
pg_restore
-c will drop database before restoring if already exists
-C will also create a database unless already exists |
Help Us Go Positive!
We offset our carbon usage with Ecologi. Click the link below to help us!
Created By
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets