cmdref.net is command references/cheat sheets/examples for system engineers.
| Cloud |
|---|
| Etc |
|---|
| Reference |
|---|
| Check version | # select version(); |
| Help | # \? # \h |
| Login Database | $ psql -U <USER_NAME> <DB_NAME> |
| Logout Database | # \q |
| List Database | # \l |
| Changee Database | # \c <DB_NAME> # \connect <DB_NAME> |
| Delete Dabase | # drop database <DATABASE_NAME>; |
| List Table | # \d # \dt |
| View table schema details. | # \d <TABLE_NAME> |
| Table access rights display. | # \z <TABLE_NAME> |
create database <DATABASE> \l #List Database
drop <DATABASE>
create table test1 (id char(4) not null, name text not null, food text not null, PRIMARY KEY(id)); \d #List Table with view table \dt #List Table without view table