Postgres

Connect

psql -h <hostname> -U <username> -d <dbname>

List databases

\l

List tables for current database

\d

Describe a tables

\d+ table_name

Quit

\q

Create database create database ct_tableau;

Drop a database drop database ct_tableau;