PostgreSQL NOTE

Hands on note for the PostgreSQL database

List out available databases

\l

Connect to database

\c database_name

List out database tables

\dt

Create new database

create database database_name;

Drop database

drop database database_name;