\d type queries - why not views in system catalog?!?

From: Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: \d type queries - why not views in system catalog?!?
Date: 2003-01-13 15:56:01
Message-ID: 20030113153831.3DCEC4980D4@sea-gw.sea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

I just came across a posting in this list, and a question arose from that
which I'm carrying for some time. PG has *some* views in the system catalog,
which make life easier, but some essential(?) things like 'list all tables in
DB' has to be done in a multi-table join with special attributes. What is the
rationale of that? Wouldn't it be easier (and more portable, see 7.3/7.2
system catalogs vs. psql) to have views for that? Do I miss a point here?

I'd be even willing to do some work here, if considered worthwhile...

Greetings,
Joerg
--
Leading SW developer - S.E.A GmbH
Mail: joerg(dot)hessdoerfer(at)sea-gmbh(dot)com
WWW: http://www.sea-gmbh.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2003-01-13 16:00:37 Re: PostgreSQL site, put up or shut up?
Previous Message Dave Page 2003-01-13 15:47:59 Re: PostgreSQL site, put up or shut up?