Received: from web1106.mail.yahoo.com (web1106.mail.yahoo.com [128.11.23.126])
	by hub.org (8.10.1/8.10.1) with SMTP id e5AA2HT44302
	for <pgsql-sql@postgresql.org>; Sat, 10 Jun 2000 06:02:18 -0400 (EDT)
Received: (qmail 9222 invoked by uid 60001); 10 Jun 2000 10:02:16 -0000
Message-ID: <20000610100216.9221.qmail@web1106.mail.yahoo.com>
Received: from [203.197.57.4] by web1106.mail.yahoo.com;
	Sat, 10 Jun 2000 03:02:16 PDT
Date: Sat, 10 Jun 2000 03:02:16 -0700 (PDT)
From: GANESH KUMAR <itsganesh@yahoo.com>
Subject: AUTO INCREMENT
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200006/109


i am searching for 
autoincrement in table 

in table employee
i want give empno as autoincrement

is there any syntax
like this
 create table emp
(empno  integer auto_increment);

send reply
ganesh

__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com