PostgreSQL DDL Operations: Difference between revisions

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


==List Databases==
==List Databases==
psql -l
or
SELECT datname FROM pg_database;


==Create a Database==
==Create a Database==

Revision as of 02:58, 26 November 2017

Internal

Database

List Databases

psql -l

or

SELECT datname FROM pg_database;

Create a Database

Drop a Database

Tablespace

List Tablespaces

\db