Database

Creating a database

image

Dropping Database

image

Commands

create database testdb;

drop database if exists testdb;

Connect to DB

-- using psql
\c test

See list of tables

-- using psql
\d                       #to see tables
\d <name of table>       #to see details about table