From: | "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, "Markus Jais" <mjais(at)web(dot)de> |
Subject: | Re: autoincrement??? |
Date: | 2001-07-13 06:06:55 |
Message-ID: | 005701c10b62$0518daa0$aa5796d4@canaan.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Use the Serial type for address_id.
And you should read the Manuals ! :)
----- Original Message -----
From: "Markus Jais" <mjais(at)web(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, July 13, 2001 12:20 AM
Subject: [GENERAL] autoincrement???
> hi
> I have the following problem:
>
> I create the following table:
>
> CREATE TABLE address (
> address_id int PRIMARY KEY ,
> street VARCHAR(40),
> zipcode INT,
> city VARCHAR(40),
> country VARCHAR(40)
> );
>
> Now, I want the address_id to get incremented
> every time I insert a value into the table.
>
> for example:
> INSERT INTO address VALUES('mainstreet 12', 85253, 'munich', 'Germany')
> ;
> without specifying a value for the id.
>
> a friend told me, that this works in MySQL with something
> like "auto_increment". I do not know much about MySQL so I do not
> know if this is true.
>
> Can you please tell me, how to do this in postgresql????
>
> thanks a lot
> regards
> markus
>
> --
> Markus Jais
> http://www.mjais.de
> info(at)mjais(dot)de
> The road goes ever on and on - Bilbo Baggins
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Micah Yoder | 2001-07-13 06:42:14 | Re: Re: Pg7.2 (was: vacuum and 24/7 uptime) |
Previous Message | Ed Loehr | 2001-07-13 05:03:43 | Re: Visual Modeling programs |