Tags

Login to postgresql
# psql -U postgres

Show all databases
# \l

Create a new database
# create database postgresdb

Connect to database
# \connect {DATABASENAME}

Show all tables
# \dt

Describe a table
# \d {TABLENAME}

Advertisements