Re: Extending System Views: proposal for 8.1/8.2

On Sat, Jan 22, 2005 at 05:21:32PM -0600, Jim C. Nasby wrote:

> Out of curiosity, what's the relation between the tables in pg_catalog
> and the 'actual system objects'? I ass-u-me'd that these tables were the
> backing store for the real information, but maybe that's not the case.

They are.

> I think these views are also very useful in certain programming
> situations, in which also having the OIDs might be very useful. Another
> option would be to have functions that given a array of names would
> return a array of OIDs.

So why not have both in the view? It's not like you are storing
duplicated data anyway.

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Ellos andaban todos desnudos como su madre los parió, y también las mujeres,
aunque no vi más que una, harto moza, y todos los que yo vi eran todos
mancebos, que ninguno vi de edad de más de XXX años" (Cristóbal Colón)