-----BEGIN PGP SIGNED MESSAGE----- I've been trying to get Keystone (http://www.stonekeep.com/keystone/) up and running. The PHP script it uses are really oriented to MySQL, although there is a mostly complete set of PostgreSQL functions written for it. One thing missing is a query to find the primary key on a table. What catalogues do I need to query to find this? Is there some documentation on the catalogues (I didn't find any, but....). On a similar note, I've managed to figure out how to find column widths but looking at the pg_attribute table and subtracting 4 from the value of atttypmod for strings, including char(). However, that was slightly non-obvious. The "old" PHP scripts looked at the attlen column which no longer seems to apply...am I doing the right thing here? roland -----BEGIN PGP SIGNATURE----- Version: 2.6.2 Comment: Processed by Mailcrypt 3.4, an Emacs/PGP interface iQCVAwUBNcUV/eoW38lmvDvNAQH6bQP/SaTCxbntNKsNqW46i7kCxpNN/YOtf0z3 ghLlC4Wh9xy/lLgFh9WOjg/Q7ecdA+jL2BCRVTVlWZG0pOwIgXWBZFAyxiz5dKSG h47jKI97RZi7C8fjXVY3H3RFnpzBtDduK0fMPoPhqXikvfcL0+LrJ9cBwVFSK4I1 6hTxhGU38hc= =25uZ -----END PGP SIGNATURE----- -- Roland B. Roberts, PhD Custom Software Solutions [EMAIL PROTECTED] 101 West 15th St #4NN New York, NY 10011
