PROTECTED]
Subject: [SQL] Auto Increment
hi all,
could anyone tell me how to make a primary key to AUTO INCREMENT. The
document is not exactly very explainatory about it :)
Thankx in advance ...
Mayuresh
---(end of broadcast)---
TIP 3: if posting
Mayuresh,
First, beginner's questions belong on the PGSQL-NOVICE list.
> could anyone tell me how to make a primary key to AUTO INCREMENT. The
> document is not exactly very explainatory about it :)
No, it is quite clear. See:
http://www.postgresql.org/idocs/index.php?datatype.html
section 3.1
Try using SERIAL:
CREATE TABLE mytable (
MYID SERIAL,
name TEXT
);
It will auto create the sequences for you.
Cory Wright
[EMAIL PROTECTED]
http://www.southcarrollton.net/
On Mon, 22 Oct 2001, Arian Prins wrote:
> On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu"
> <[EMAIL PROTECTED]>
hi all,
could anyone tell me how to make a primary key to AUTO INCREMENT. The
document is not exactly very explainatory about it :)
Thankx in advance ...
Mayuresh
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu"
<[EMAIL PROTECTED]> wrote:
>hi all,
>
>could anyone tell me how to make a primary key to AUTO INCREMENT. The
>document is not exactly very explainatory about it :)
>
>Thankx in advance ...
>
>
>
>Mayuresh
>
>
Try first creating a sequence and t
Hi
I'm a newbiw with pgsql:
1: Haven't been able to find the officiel manual to pgsql. What's the
complete URL?
2: How can I make an auto increment with PostGreSQL? is it "inherit"?
3: The "SHOW TABLE FROM pcfocus" statement, does it work in pgsql?
If yes, what kind of variable will be "produced
Check manual/user for details on 'sequences'.
Good luck.
-Message d'origine-
De : [EMAIL PROTECTED] <[EMAIL PROTECTED]>
À : GANESH KUMAR <[EMAIL PROTECTED]>
Cc : [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date : samedi 10 juin 2000 12:12
Objet : Re: [SQL] AUTO
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://ww
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