Re: Create table syntax - Mailing list pgsql-sql

On 28 Aug 2001, satish rao  wrote:

> 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)

create table lists (listid serial not null,listname varchar(200),listcreator varchar(200),listdesc text);

(You may want to make listid a primary key as well)