Thread: AUTO INCREMENT

i am searching for 
autoincrement in table 

in table employee
i want give empno as autoincrement

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

send reply
ganesh

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

On Sat, 10 Jun 2000, GANESH KUMAR wrote:
> i am searching for 
> autoincrement in table 
> 
> in table employee
> i want give empno as autoincrement
create table xyz (id serial primary key);
check documentation what it really is:).


Marcin Mazurek

-- 
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/

Check manual/user for details on 'sequences'.
Good luck.

-----Message d'origine-----
De : M.Mazurek@poznan.multinet.pl <M.Mazurek@poznan.multinet.pl>
À : GANESH KUMAR <itsganesh@yahoo.com>
Cc : pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Date : samedi 10 juin 2000 12:12
Objet : Re: [SQL] AUTO INCREMENT


>On Sat, 10 Jun 2000, GANESH KUMAR wrote:
>> i am searching for
>> autoincrement in table
>>
>> in table employee
>> i want give empno as autoincrement
>create table xyz (id serial primary key);
>check documentation what it really is:).
>
>
>Marcin Mazurek
>
>--
>administrator
>MULTINET SA o/Poznan
>http://www.multinet.pl/
>