Re: your mail

On Wed, 27 Jan 1999, wrote:

> Hello.
>
> Before SERIAL type appeared I used INTEGER, so it was easy
> to add instance which is stored not in one table. Now when I
> have a primary key of SERIAL type I do not know how to add
> data to multiple tables (and even to one table too :)

If you have a column of SERIAL type, you have the option of not
specifying it in the column-list part of your INSERT statement.
PostgreSQL will add the next available integer to the serial type.

So if you create a table like so:

create table companies (
co_id serial,
co_name text);

You can INSERT like so:

insert into companies (co_name) values ('Microsoft');
insert into companies (co_name) values ('Netscape');

and assume that PostgreSQL will assign the lowest available integer
to your co_id field.

Note that you CAN specify a co_id when you do an insert, if you want to.

Brian