create table in postgres database
I want to create a table in postgres database with following format...
table name: emp_info
"emp_info_id_key" unique, btree (id, address)
"emp_info_name_key" unique, btree(name, address)
Theoretically, it is not possible to create multiple primary keys for a table. Hence I'm not able to create this type of table. Is any thing other than primary key is required to create such a table?
Thanks in advance,