user3663882
Reputation: 7357
Create foreign key to a non-primary key?
Is it possible to create a foreign key constraint to a non-primary key column which is UNIQUE? I'm using PostgreSQL 8.4.
Upvotes: 1
Views: 1174
Answers (1)
Denys Séguret
Reputation: 382132
Yes.
From the documentation:
Finally, we should mention that a foreign key must reference columns that either are a primary key or form a unique constraint.
Upvotes: 5
Related Questions
- Postgres: two foreign keys to same primary key field
- How do I convert an existing column to Foreign Key?
- How to add foreign key in PostgreSQL
- Create a foreign key from elements of a composite primary key
- create a foreign key on a primary key of another table
- How do I make a foreign key to an already created PostgreSQL table?
- Is possible to create a foreign key without a primary key?
- creating a table with reference to a non primary key column
- How do I create this FOREIGN KEY? - Postgres
- Changing type of primary key when you have foreign key constraint