PostgreSQL DDL Operations: Difference between revisions
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