Postgres How-to(s)

SHOW TABLE:
Postgres psql needs escaping for capital letters.
Database=# \d+ "TestTable1"

Describe Table:
 \d "myTable" describe table
 \d+ "myTable"

Switch Database
\c tableName

Create Database:
create database "testdb2" OWNER postgres;

\q + enter -> Exit;

Import Database:
psql -U postgres database < SqlScript.sql'

Creating Roles
CREATE USER node_user WITH SUPERUSER PASSWORD 'node_password';

Checking for Users
SELECT * FROM PG_USER;

Update
UPDATE database SET column($1) WHERE id=($2), [$1 value, $2 value]

Delete
DELTE from databsae where id=

Started a Gist regarding Postgres commands