Re: [GENERAL] How to get table/DB info

On Sat, Mar 04, 2000 at 05:47:22PM -0800, Jeff Davis wrote:
> This is a follow up to my previous question about this
> subject.
>

Jeff -
Sorry no-one replied to your earlier messsage: have you looked
at the -E switch to psql? It'll echo all the queries sent to the
backend, so to find out how \d tablename works, just do:

psql -E test
...

test=> \d no_such_table
QUERY: SELECT a.attnum, a.attname, t.typname, a.attlen, a.atttypmod,
a.attnotnull, a.atthasdef FROM pg_class c, pg_attribute a, pg_type t
WHERE c.relname = 'no_such_table' and a.attnum > 0 and a.attrelid =
c.oid and a.atttypid = t.oid ORDER BY attnum

Couldn't find table no_such_table!
test=>

And so on. You might want to use 'transcript' to grab a copy of your
entire session (I think that'll work) and do a bunch of \d commands that
you're interested in.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005