\l |
list databases |
\c DATABASE NAME |
connect/switch to database |
\dt |
list tables |
\d TABLE NAME |
describe table |
\o FILE NAME \o |
save query result to a file |
\! shell command |
run external shell command |
You can do \l to list all the databases, use
\c to connect to one database, use \d to list
tables in this database