Skip site navigation (1) Skip section navigation (2)

Re: How to detect primary key of a table

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Sergey Karin <sergey(dot)karin(at)gmail(dot)com>
Cc: Michael Kleiser <Michael(dot)Kleiser(at)combots(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: How to detect primary key of a table
Date: 2006-03-30 11:30:56
Message-ID: 442BC170.8000204@wildenhain.de (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2006-03-30 11:38:07
Subject: Re: converting timstamptz to local time zone
Previous:From: Sergey KarinDate: 2006-03-30 11:25:51
Subject: Re: How to detect primary key of a table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group