PostgreSQL DDL Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 14: Line 14:


==Create a Database==
==Create a Database==
createdb <''dbname''>
or
CREATE DATABASE


==Drop a Database==
==Drop a Database==

Revision as of 02:59, 26 November 2017

Internal

Database

List Databases

psql -l

or

SELECT datname FROM pg_database;

Create a Database

createdb <dbname>

or

CREATE DATABASE

Drop a Database

Tablespace

List Tablespaces

\db