...

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 :)

For instance I have:
create table companies(
 id serial primary key,
 ...
);
create table ccats(
 cid integer not null references companies(id),
 catid integer not null references categories(id)
);

What do I have to put instead of ??:
insert into companies values (??, ...);
insert into ccats (??, 5);
...
insert into ccats (??, 7);

Andrey.