Is foreign key should be unique?
Answer / Amt Dinesh Kumar Asthana
In most cases, a foreign key in a PostgreSQL table does not need to be unique. However, the primary key of the referenced table should be unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you edit a table in pgadmin?
What is greenplum db?
How to setup postgresql sysv startup script?
Is postgresql similar to sql server?
What is serial data type in postgresql?
How to take backup of database?
Does postgres use sql?
PostgreSql Disadvantages
What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?
How to insert data from one table to another in postgresql?
Do foreign keys speed up queries?
How to select distinct on multiple columns?
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)