Convert from Mysql to Postgresql

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Convert from Mysql to Postgresql
Date: 2002-02-11 21:53:30
Message-ID: 00fa01c1b346$8ba7d800$3200a8c0@jecinc.on.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Could someone tell me the SQL for an equivalent table in PostgreSQL?

CREATE TABLE palm_addressbook (
cal_id int(11) NOT NULL default '0',
account_id int(11) NOT NULL default '0',
palm_rec_id int(11) NOT NULL default '0',
PRIMARY KEY (cal_id,account_id),
UNIQUE KEY account_id (account_id,palm_rec_id)
) TYPE=MyISAM;

I think it would be

CREATE TABLE palm_addressbook (
cal_id int4 NOT NULL default '0',
account_id int4 NOT NULL default '0',
palm_rec_id int4 NOT NULL default '0',
PRIMARY KEY (cal_id,account_id)
);

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Klatt 2002-02-11 22:00:12 Read-only attributes
Previous Message btt 2002-02-11 21:37:59 Re: C Function Question