Developing a Schema

Поиск
Список
Период
Сортировка
От Steven Pennie
Тема Developing a Schema
Дата
Msg-id s8b3ac5d.087@165.201.21.73
обсуждение исходный текст
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Vazsonyi
Дата:
Сообщение: more performance on some aggregates
Следующее
От: "Hernan J. Gonzalez"
Дата:
Сообщение: bug with serial field?