PostgreSQL

Postgres is a database. This is a bit of a cheat sheet.

Enumerated types

I generally still prefer tables, but this is quicker/easier.

Creating

CREATE TYPE arch32 AS ENUM ('x86','macppc','sparc','alpha');

Listing all properties

\dT+ arch32

Listing values (simpler)

select enum_range(null::arch32);

Export SQL for later insertion

pg_dump -h $HOST -U $USER --dbname $DATABASE -t $TABLE \
  --data-only --column-inserts > $TABLE.sql

Useful links

• Dalto Curvelano: Introduction to PostgreSQL Indexes