PostgreSQL

Popular & Fast Relational Databases

psql Commands

• End every statement with ;. Otherwise they are not executed

# list postgres commands
\?
 
# list db commands
\h
 
# list users
\du+
 
# list databases
\l
 
# list schemas
\dn
 
# create user
CREATE USER myuser WITH CREATEROLE CREATEDB PASSWORD '1234';
 
# modify table
ALTER TABLE actingentity DROP COLUMN test;
ALTER TABLE actingentity ADD COLUMN test varchar(255);
 
# check if auditing is enabled
SELECT name,setting FROM pg_settings WHERE name LIKE 'pgaudit%';