Basic Postgresql Commands
Book page
kitt decided around 18:28 on 25 November 2004 to publish this:
|
Command |
Result |
|
\d |
|
|
\dt |
List all tables |
|
\di |
List all indexes |
|
\ds |
List all sequences |
|
\dv |
List all views |
|
\dS |
List all PostgreSQL-defined tables |
|
\d table-name |
Show table definition |
|
\d index-name |
Show index definition |
|
\d view-name |
Show view definition |
|
\d sequence-name |
Show sequence definition |
|
\dp |
List all privileges |
|
\dl |
List all large objects |
|
\da |
List all aggregates |
|
\df |
List all functions |
|
\df function-name |
List all functions with given name |
|
\do |
List all operators |
|
\do operator-name |
List all operators with given name |
|
\dT |
List all types |
|
\l |
List all databases in this cluster |