mysql create table -> psql

From: expect <expect(at)ihubbell(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: mysql create table -> psql
Date: 2003-09-09 06:10:52
Message-ID: 20030908231052.01eb3255.expect@ihubbell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

Trying to get this MySql create table command to work, no luck.

create sequence serial;

CREATE TABLE outbound (
source char(100) default '',
destination char(100) default '',
sport int4 default 0 NOT NULL,
dport int4 NOT NULL default 0,
time timestamp NOT NULL default '0000-00-00 00:00:00',
id int8 default nextval('serial') not null,
constraint id PRIMARY (id)
);

I get a parse error:
ERROR: parser: parse error at or near "(" at character 279

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-09 06:23:09 Re: Views and Limits
Previous Message Tom Lane 2003-09-09 05:54:10 Re: Another pimple on the type system