Home > mailing lists

Create table syntax - Mailing list pgsql-sql

From	satish rao
Subject	Create table syntax
Date	August 30, 2001 15:59:50
Msg-id	20010828071121.1863.qmail@mailweb22.rediffmail.com Whole thread Raw
Responses	Re: Create table syntax (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List	pgsql-sql

Tree view

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
postgresql while creating the table and the
autoincrement option for the column(listid). If this
syntax is not correct for postgresql, we need the
correct syntax.

Hoping for a positive response from ur side.

Regards

Satish Rao

pgsql-sql by date:

From: jake@omnimode.com (jake johnson)
Date: 30 August 2001, 15:59:36
Subject: DBD::Pg install error (freebsd)

From: "Jaydip"
Date: 30 August 2001, 16:04:43
Subject: Help On Postgresql

Create table syntax - Mailing list pgsql-sql

Previous

Next