PostgreSQL DDL Operations

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

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