Re: autoincrement???

You could either try:

CREATE TABLE address (
  address_id int SERIAL,
  street VARCHAR(40),
  zipcode INT,
  city VARCHAR(40),
  country VARCHAR(40)
);


Or you could do the same thing yourself manually with:

CREATE sequence address_id_seq;

CREATE TABLE address (
  address_id int PRIMARY KEY DEFAULT
nextval('address_id_seq'),
  street VARCHAR(40),
  zipcode INT,
  city VARCHAR(40),
  country VARCHAR(40)
);

I personally like the latter as it is slightly more
flexible.  Plus, I often create large SQL scripts to
rebuild the database schema when I am developing and
the longer way reminds me that I need to drop the
sequence before creating the table :).

Jason

--- Markus Jais <mjais@web.de> wrote:
> 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@mjais.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@postgresql.org
> so that your
> message can get through to the mailing list cleanly


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/