REFERENCES reftable [ ( refcolumn ) ] [ MATCH matchtype ] [ ON DELETE action ] [ ON UPDATE action ] (column constraint)FOREIGN KEY ( column [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ] [ MATCH matchtype ] [ ON DELETE action ] [ ON UPDATE action ] (table constraint)
To be precise, The difference betweencreate table a ( foreign key (id) referenced by b(name), );create table b( id integer referenced by b(name),);
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных