>
>
>Which leads to :
>
>CREATE TABLE shops ( id_shop SERIAL PRIMARY KEY, id_cust integer
>REFERENCES customers, .......)
You can't reference to a table who doesn't exists still.
>CREATE TABLE customers ( id_cust SERIAL PRIMARY KEY, id_defaultshop
>integer REFERENCES shops, .......)
Perhaps you can do it something like that if:
1.- Create the two tables.
2.- Use alter table to add the constraint "references".