Common SQL
PostgreSQL
Manual
Connect
psql
psql -U xxx -d postgres
psql -U xxx -d postgres -p
List Databases
\l
List Tables
\dt
Select Database
\c xxx
Create Database
CREATE DATABASE foo
WITH
OWNER = kuga
ENCODING = 'UTF8'
LC_COLLATE = 'C'
LC_CTYPE = 'C'
TEMPLATE = t...
