Table of Contents

PostgreSQL


Table of Contents


SQL

Check version # select version();
Help # \?
# \h

Database

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>;

Table

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>;

User

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

Schema Creation # create schema <schema_name>;
Check the schema # select current_schema;
Schema List # \dn
Schema changes # set search_path to <schema_name>;

Creata Database

create database <DATABASE>

\l  #List Database

drop <DATABASE>

Creata Table

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