Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7UEogf44577 for ; Thu, 30 Aug 2001 10:50:42 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mailweb22.rediffmail.com ([203.199.83.146]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7S7Cwf90825 for ; Tue, 28 Aug 2001 03:13:01 -0400 (EDT) (envelope-from csr_del@rediffmail.com) Received: (qmail 1864 invoked by uid 510); 28 Aug 2001 07:11:21 -0000 Date: 28 Aug 2001 07:11:21 -0000 Message-ID: <20010828071121.1863.qmail@mailweb22.rediffmail.com> Received: from unknown (63.109.254.51) by rediffmail.com via HTTP; 28 Aug 2001 07:11:21 -0000 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Create table syntax From: "satish rao " Content-ID: Content-type: text/plain Content-Description: Body Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200108/365 X-Sequence-Number: 4624 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. Hoping for a positive response from ur side. Regards Satish Rao =20 =20