PostgreSQL array of elements that each are a foreign key
It may soon be possible to do this: https://commitfest.postgresql.org/17/1252/ – Mark Rofail has been doing some excellent work on this patch! The patch will (once complete) allow CREATE TABLE PKTABLEFORARRAY ( ptest1 float8 PRIMARY KEY, ptest2 text ); CREATE TABLE FKTABLEFORARRAY ( ftest1 int[], FOREIGN KEY (EACH ELEMENT OF ftest1) REFERENCES PKTABLEFORARRAY, ftest2 int ); … Read more