Postgres MetaCommands Cheat Sheet
Cheat Sheet that serves as a quick reminder of many of the most common and useful metacommands.
|
Meta Command |
Description |
|
\l |
List Database in current connection to Database |
|
\c <database> |
Connect to a database |
|
\dt |
List Database Tables |
|
\d <tablename> |
Describe Table |
|
\dn |
List Schemas |
|
\du |
List Users and their Roles |
|
\du <user> |
List details about a specific user |
|
\df |
List Functions |
|
\dv |
List Views |
|
\o <filename> |
Save query results to a file |
|
\i <filename> |
Execute commands inside a file |
|
\q |
Quit psql |
