I am working on SQLs to be used to develope a "schema" of whatever database I am using. I thought I would start by
mimicingthe "\d" command and build on from there. What is the SQL that generates the "\d" description? What I have so
faris:
SELECT relname,typrelid,attname,tableowner,relowner,
reltype,reltuples,relhasindex,relukeys,relfkeys,relhasrules
FROM pg_class c, pg_tables t, pg_type y, pg_attribute a
WHERE relname NOT LIKE 'pg_%' AND relname=tablename AND
typname=relname AND attrelid=typrelid AND attnum > 0
ORDER BY relname;"
I noticed that pg_class.reltuples didn't always gave me the number of rows in a table, several times it had 1000
instead
Steven Pennie
Application Programmer/Analyst III
KDOT Materials & Research Center
(785) 291-3863 - Fax (785) 296-2526
steven@ksdot.org
