Timescale Logo

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)

Timescale Logo

Subscribe to the Timescale Newsletter

By submitting, I acknowledge Timescale’s Privacy Policy
2024 © Timescale Inc. All rights reserved.