Re: Obtener lista de tablas de una bd.

On Fri, Sep 16, 2005 at 08:25:56AM -0400, Rodrigo Cortés wrote:

> SELECT n.nspname, c.relname
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
> WHERE c.relkind IN ('r','')
> AND n.nspname NOT IN ('pg_catalog')
> AND pg_catalog.pg_table_is_visible(c.oid);
>
> Eso me devuelve la lista de tablas en la base de datos activa. Lo que
> no se es si es necesario especificar "pg_catalog".

Hay cuatro ocurrencias de "pg_catalog" en tu consulta. A cual o cuales
de ellas te refieres? En principio todas son necesarias, puesto que no
se prohibe que un usuario cree una tabla pg_class en cualquier schema.

--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Before you were born your parents weren't as boring as they are now. They
got that way paying your bills, cleaning up your room and listening to you
tell them how idealistic you are." -- Charles J. Sykes' advice to teenagers