Using the internal data dictionary - Mailing list pgsql-general

From Bill Thoen
Subject Using the internal data dictionary
Date
Msg-id 0DE1A2C7-865F-4AAB-97C3-2786029B1975@gisnet.com
Whole thread Raw
Responses Re: Using the internal data dictionary  (David Johnston <polobo@yahoo.com>)
Re: Using the internal data dictionary  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
I need to assemble a complete data dictionary for project documentation and other purposes and I was wondering about
thepros and cons of using the pg_catalog metadata. But I hesitate to poke around in here because I don't know why it's
keptso out of sight and not much documented. But it seems like an ideal source of information to tap with a program to
generateaccurate, current reports of what's in the database. 

Is this a bad idea (everything I'm thinking of doing would be read only except for the description fields) but I'd just
liketo make sure that there's not some innocent looking table in there that acts as a doomsday device if you so much as
readits first record, etc.  I'm just not sure why this isn't more widely used or talked about. 

Regards,

Bill Thoen
GISnet
http://gisnet.com
303-786-9961

pgsql-general by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: Huge number of INSERTs
Next
From: David Johnston
Date:
Subject: Re: Using the internal data dictionary