PostgreSQL DDL Operations

Internal

• Postgreql Operations

Database

List Databases

psql -l

or

SELECT datname FROM pg_database;

Create a Database

createdb <dbname>

or

CREATE DATABASE

Drop a Database

DROP DATABASE

Tablespace

List Tablespaces

psql
\db

Users

List Users

psql
\du