Re: How to identify primary key
| From: | Ross Honniball | Date: | Tue, 01 Jun 2004 23:03:02 +0000 |
| Subject: | Re: How to identify primary key | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34622@lists.php.net to get a copy of this message | ||
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@cfl.rr.com> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php. . Ross Honniball. JCU Bookshop Cairns, Qld, Australia. .