One-to-many foreign key constraints in postgres?

Question

I was wondering if there is a good way to model one to many relationships with postgres 9.6 (i.e. have an array of foreign keys). I know its doable via junction tables but I'm wondering if there's a simpler solution (like creating a custom trigger/constraint in postgres). Thanks!

I want to have a single row in a table be able to reference multiple rows in foreign tables — Austin Varela
– Austin Varela, Commented Jul 11, 2017 at 14:06
Please Edit your question and add the create table statements for the tables in question and a description on how exactly you want to define those foreign keys. Formatted text please, no screen shots — user330315
– user330315, Commented Jul 11, 2017 at 14:28

Gurmokh · Accepted Answer · 2017-07-11 14:29:13Z

Sounds like you want to reference many tables from a single row. Something like this will do it.

CREATE TABLE a( columnA integer references B(columnName) , columnB integer references C(columnName) , columnC integer references D(columnName) , etc....... );

In my opinion something like this is asking for a headache.

Eduardo Lima · Accepted Answer · 2017-07-11 14:27:41Z

Having a variety of foreign keys is not a problem. This is part of the entity-relationship model and its normal forms.

N-N relationship entities should only be used in many-to-many cases.

If your table has many foreign keys, the logical model of your data must be verified, it may be poorly modeled.

Collectives™ on Stack Overflow

One-to-many foreign key constraints in postgres?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related