What is composite primary key?
Answer / Monu Sharma
In PostgreSQL, a composite primary key (also known as a compound primary key) is a combination of two or more columns that together serve to uniquely identify each row in a table. This is represented by creating the PRIMARY KEY constraint on multiple columns.n`CREATE TABLE table_name (column1 data_type, column2 data_type, ... PRIMARY KEY (column1, column2));`
| Is This Answer Correct ? | 0 Yes | 0 No |
List different advantages of postgresql?
What is difference between drop and delete?
How to start, stop and restart postgresql database?
Is postgresql free for commercial use?
Can postgres scale horizontally?
How many rows can postgresql handle?
Who maintains postgresql?
What does psql command do?
Where is pg_hba conf?
What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed?
How do you create a table in pgadmin?
How do I rename a column in postgresql?
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)