Re: Create table syntax

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.