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