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 |
| Change Database | # \c <DB_NAME> # \connect <DB_NAME> |
| Delete Dabase | # drop database <DATABASE_NAME>; |
| List Table | # \d #List Table with view table # \dt #List Table without view table |
| View table schema details. | # \d <TABLE_NAME> |
| Table access rights display. | # \z <TABLE_NAME> |
| Delete Table | # drop table <TABLE_NAME>; |
| Show current user (role) | # select current_user; |
| Display the list of users (roles) | # \du |
| Display user information list | # select * from pg_user; |
| Switching users | # \connect - <USER_NAME> |
| Schema Creation | # create schema <schema_name>; |
| Check the schema | # select current_schema; |
| Schema List | # \dn |
| Schema changes | # set search_path to <schema_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