Useful PosgreSQL Commands

Please add commands which you have found useful...

using `psql` (_the Postgres shell_)

Create a new Database:

``` sh
CREATE DATABASE dbname;
```

To connect to ("use") a specific database

``` sh
\c dbname
```

> http://stackoverflow.com/questions/10335561/use-database-name-command-in-postgresql

Show (_list of_) Tables (_for a given database_):

``` sh
\dt
```

> http://stackoverflow.com/questions/769683/show-tables-in-postgresql