Postgres SQL Operations

To login Postgres SQL using CLI

psql -h localhost -U admin --password -p [port] postgresdb

create database aftab;

To switch database

\c databasename;

To get database list

\l

\list

To see the tables