Alexander Kleinhans
Reputation: 6248
Syntax to alter and create composite foreign key in postgres
I have a table in Postgres with a composite primary key.
What's the syntax to alter another existing table to add a composite foreign key to the composite primary key of the first table?
Upvotes: 3
Views: 2162
Answers (1)
Dan Ganiev
Reputation: 1062
ALTER TABLE my_fk_table
ADD CONSTRAINT my_fk
FOREIGN KEY (pk1, pk2)
REFERENCES my_pk_table
ON DELETE CASCADE;
Upvotes: 5
Related Questions
- How to consider one key among composite primary keys in a table as a foreign key in a another table in postgres
- Create a foreign key from elements of a composite primary key
- How to alter a foreign key in postgresql
- Change primary key from simple to composite with new column
- Postgres: How to do Composite keys?
- Postgresql add existing column to composite primary key
- Postgres - insert and composite foreign keys
- Changing type of primary key when you have foreign key constraint
- Changing a primary key to a composite primary key
- Adding foreign key constraint to 'partial' primary key in PostgreSQL