Useful commands: Only shot-cut commands:
Command
|
Description
|
\l or \list
|
List
all the databases created
|
\c database_name
|
To
connect a database
|
\dt schema.*
|
List
all the tables in a schema
|
\q
|
Quit
|
\db
|
List
of tablespaces
|
\dn
|
List
all schemas in postgres
|
\d
|
List
of relations / Tables
|
\d
schema.table_name
|
Describe
structure of the table
|
\dt *
|
All
Tables
|
\dv
*
|
All
views
|
\ds *
|
All
sequences
|
\e
|
(Edit)
Modify the query buffer
|
\g
|
(Go)
Execute the query buffer
|
\s
|
(Search)
Last commands used
|
\r
|
(Reset)
Clears the query buffer
|
SELECT
spcname FROM pg_tablespace;
|
List
all tablespaces
|
select * from pg_namespace;
|
List
all schemas
|
\h
|
Display
help on Command
|
\i
|
read
name into query buffer (input)
|
\o
name
|
Send
output to name
|
\p
|
Display
the query buffer
|
\t
|
Toggle
the output headers on/ off
|
\w
name
|
Write
the query buffer to name
|
\!
|
Execute
the Linux command
|
\?
|
Help
on meta-commands
|
\x
|
display in transpose mode
|
Most of cases you can use '+' to display more information for same command.
e.f.
\dt (display table information)
\dt+ ( display table information with addition columns)
