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