\l
// List all databases using \l (or \list) (psql)
\l+
// List all databases using \l+ with more details (including description, tablespace & DB size) (psql)
CREATE DATABASE
command syntax
\h CREATE DATABASE
// Help on SQL Command Syntax (For e.g. CREATE DATABASE) (psql)
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)