Migrating from mysql.

Hi there,

I'm migrating from MySQL to PostgreSQL and I was wondering whether someone
could help me match some datatypes.

Firstly MySQL has a 'timestamp' datatype which automatically updates with
the current timestamp whenever an instance containing it is inserted or
updated.  Is there an equivalent datatype in PostgreSQL?

Secondly MySQL supports an 'enum' datatype which allowed a number of
labels to be defined as valid datatypes for a column, i.e:

  create table account (
      status enum('cancelled','active','onhold') DEFAULT 'active' NOT NULL
      ...
  )

I can't seem to find the equivalent in PostgreSQL.  Is there a way of doing
this?


And last but not least I'm used to using the 'desc tablename' sql command
to show the structure of a table within MySQL.  How do I do the same in
PostgreSQL.

Many thanks in advance,
Joe