Can we add foreign key without primary key?
Answer / Nupur Tandon
No, it is not possible to add a foreign key constraint without a corresponding primary key in PostgreSQL. The foreign key references the primary key of another table, ensuring that each value in the foreign key column corresponds to a unique value in the referenced primary key column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Where is pg_hba conf?
Does aws support postgresql?
How do you delete a row in pgadmin 4?
What is ora2pg?
Explain about functions in PostgreSQL?
Is postgresql a relational database?
What does create schema do?
Is postgresql case sensitive?
What is psql?
What does truncate table do?
How to list the number of database?
What is composite foreign key?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)