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

Поиск
Список
Период
Сортировка
От Joerg Hessdoerfer
Тема \d type queries - why not views in system catalog?!?
Дата
Msg-id 20030113153831.3DCEC4980D4@sea-gw.sea.com
обсуждение исходный текст
Ответы Re: \d type queries - why not views in system catalog?!?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: \d type queries - why not views in system catalog?!?  (greg@turnstep.com)
Список 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.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com


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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: PostgreSQL site, put up or shut up?
Следующее
От: Robert Treat
Дата:
Сообщение: Re: PostgreSQL site, put up or shut up?