Re: Porting from MySql - meta data issues

En Fri, 05 Apr 2002 17:13:40 +0100
Geoff Caplan <geoff@advantae.com> escribió:

> Thanks folks - useful responses.
>
> In the longer run, though, it would be good if there were a more accessible
> set of functions or queries (such as the MySql SHOW queries), which made
> this kind of meta-data more accessible.

You can also use the pg_tables view, for example, and the system
catalogs for the rest (pg_database, pg_attribute).

Anyway, there's little use for SHOW queries, as you can always poke into
the system catalogs. That's something you can't do in MySQL, and is the
reason for the SHOW hack.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Everybody understands Mickey Mouse. Few understand Hermann Hesse.
Hardly anybody understands Einstein. And nobody understands Emperor Norton."