how to find primary key field name?
От | J.V. |
---|---|
Тема | how to find primary key field name? |
Дата | |
Msg-id | 4E94C911.6030003@gmail.com обсуждение исходный текст |
Ответы |
Re: how to find primary key field name?
Re: how to find primary key field name? Re: how to find primary key field name? Re: how to find primary key field name? Re: how to find primary key field name? |
Список | pgsql-general |
If I have a table name, I know how to find the primary key constraint name, but see no way to find the primary key field name. select constraint_name from information_schema.tabale_constraints where table_name = <table_name> and constraint_type = 'PRIMARY KEY'; will return the constraint name, but given the table_name and the constraint_name, how do I find the database column/field name associated with that primary key? J.V.
В списке pgsql-general по дате отправления: