Migrating from mysql.

From: Joe Karthauser <joe(at)pavilion(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Migrating from mysql.
Date: 2000-05-15 22:04:48
Message-ID: 20000515230448.A63003@pavilion.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dragos Stoichita 2000-05-16 00:59:26 Why is the INTERSECT so slow?
Previous Message Charles Tassell 2000-05-15 21:39:11 Re: Performance