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
