mysql create table -> psql - Mailing list pgsql-general

From expect
Subject mysql create table -> psql
Date
Msg-id 20030908231052.01eb3255.expect@ihubbell.com
Whole thread Raw
Responses Re: mysql create table -> psql  (Ian Barwick <barwick@gmx.net>)
Re: mysql create table -> psql  (Richard Huxton <dev@archonet.com>)
Re: mysql create table -> psql  (Scott Cain <cain@cshl.org>)
Re: mysql create table -> psql  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
List 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


pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: SRF question
Next
From: Tom Lane
Date:
Subject: Re: Views and Limits