Postgres Pro
Downloads
Home   >   mailing lists

Re: How to detect primary key of a table - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: How to detect primary key of a table
Date
Msg-id 442BC170.8000204@wildenhain.de
Whole thread Raw
In response to Re: How to detect primary key of a table  ("Sergey Karin" <sergey.karin@gmail.com>)
List pgsql-general
Tree view 
Sergey Karin schrieb:
>
> Yes, it is not a problem via psql.
>
> But I want to detect primary key via libpq (e.g using select commands)
>
Look into informational-schema
or start psql with the option -e
then use \d+ and see what it prints :-)

Regards
Tino

pgsql-general by date:

Previous
From: "Sergey Karin"
Date:
Subject: Re: How to detect primary key of a table
Next
From: Martijn van Oosterhout
Date:
Subject: Re: converting timstamptz to local time zone