Re: How to identify primary key

[Ross Honniball <ross@xxxxxxxxxxxxxxxxxxx>]

May not be of any use as I know nothing about postgresql, but if it happens 
to be remotely related to mysql then this may help.

In Mysql : SHOW COLUMNS FROM table-name

Regards .. Ross

At 05:04 AM 2/06/2004, you wrote:
> Using PHP 4.2.2 and postgresql 7.2.4.
>
> Trying to find a way to identify the primary key of a table given just
> the tables name.
>
> Been looking through the system tables but have not figured out some of
> the relationships between pg_attribute, pg_class and some of the others.
>
> Found a reference to a pg_get_indexdef() function but the details were
> less than complete.
>
> So is there nice way to get this information?
>
> --
> Scot L. Harris <webid@xxxxxxxxxx>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

.
. Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php