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 <[EMAIL PROTECTED]>

--
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



Reply via email to