Re: Retrieve the primary key of a table
От | Michael Wood |
---|---|
Тема | Re: Retrieve the primary key of a table |
Дата | |
Msg-id | 5a8aa6680908030558h3e356ec9ifc12ba97149bd88c@mail.gmail.com обсуждение исходный текст |
Ответ на | Retrieve the primary key of a table (Alejandro <apinoo@gmail.com>) |
Список | pgsql-novice |
Hi 2009/8/3 Alejandro <apinoo@gmail.com>: > Hi. I need to retrieve the primary key of a table and their value. > > I tried with this > http://wiki.postgresql.org/wiki/Retrieve_primary_key_columns: > > SELECT > pg_attribute.attname, > format_type(pg_attribute.atttypid, pg_attribute.atttypmod) > > FROM pg_index, pg_class, pg_attribute > WHERE > pg_class.oid = 'TABLENAME'::regclass AND > > indrelid = pg_class.oid AND > pg_attribute.attrelid = pg_class.oid AND > > pg_attribute.attnum = any(pg_index.indkey); > > But this shows indexes too. > http://wiki.postgresql.org/wiki/Talk:Retrieve_primary_key_columns > > How can I get only the primary key? > > I have postgres 8.1.11. If you run "psql -E" it will show you all the queries it runs when you type "\d tablename" and other similar commands. I think you should be able to work out from that what the query should be. -- Michael Wood <esiotrot@gmail.com>
В списке pgsql-novice по дате отправления: