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
the
autoincremention. This Statement should do what you want.

Arne.