Console

$ psql

Commands

  • Show tables: \dt
  • Show databases: \l
  • Show columns of a table: \d table or \d+ table

Creating database

 $ createdb databasename