I'm writing an admin client for postgres and I'm having a tough time
figuring out how some of the system tables work. I have two questions:
1) Is there any place where the system tables and their fields and uses are
documented? I can piece together some of the function by doing things in
psql and watching what queries get generated, but I have not found answers
to all my questions, for example:
2) Which system tables do I query to find all the PRIMARY KEY and UNIQUE
constraints on a table? Other tools I have seen do this do it by find all
indexes for a table but this doesn't seem to distinguish between PRIMARY KEY
That's probably enough for now. Thanks in advance for any help.
Senior Project Manager
Chris Moyer Consulting Inc., Chicago
833 W. Chicago Ave. Suite 203
Chicago, IL 60622
312 433-2421 (V) slane(at)fmpro(dot)com
312 850-3930 (F) http://www.fmpro.com
Beginner to Advanced FileMaker & Lasso training.
For class and registration information, please visit
email training(at)fmpro(dot)com, or call Josie Graham at 404-467-9301.
pgsql-admin by date
|Next:||From: Rainer Mager||Date: 2000-12-19 11:31:57|
|Subject: SQL statement limit|
|Previous:||From: Jimi Thompson||Date: 2000-12-18 22:17:13|
|Subject: Re: RE: Postgresql on Solais 7|