PostreSQL Cheatsheet

PostgreSQL

Use the psql interactive terminal

psql

Use the psql interactive terminal with the user 'postgres'

psql -U postgres

List all Databases

\l

Drop database with name ABC

drop database ABC;

Create database with name ABC

create database ABC;