[SQL] Re: Create table syntax

[Arne Weiner]

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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]