Re: How to identify primary key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux