satish rao wrote:
>
> Hi
>
> Entered below is the SQL create table syntax:
>
> CREATE TABLE lists (
> [listid] [int] IDENTITY (1, 1) NOT NULL ,
> [listname] [varchar] (200) NULL ,
> [listcreator] [varchar] (200) NULL ,
> [listdesc] [text] NULL)
>
> We need to know that this syntax will work properly in=20
> postgresql while creating the table and the=20
> autoincrement option for the column(listid). If this=20
> syntax is not correct for postgresql, we need the=20
> correct syntax.
>
CREATE TABLE lists ( listid SERIAL NOT NULL , listname varchar(200) NULL , listcreator
varchar(200)NULL , listdesc text NULL);
This create statement is accepted from postgres. The type SERIAL does
theautoincremention. This Statement should do what you want.
Arne.
