Databases

List databases

\l

// List all databases using \l (or \list) (psql)

\l+

// List all databases using \l+ with more details (including description, tablespace & DB size) (psql)

Help on CREATE DATABASE command syntax

\h CREATE DATABASE

// Help on SQL Command Syntax (For e.g. CREATE DATABASE) (psql)

Create database

CREATE DATABASE mytest;

// Creates a new database “mytest” (SQL)

By default, the owner of the database is the current login user.

\c test You are now connected to database "test" as user "postgres".

// Connect to a PostgreSQL database “test” as “postgres” user (psql)