Re: list tables Examples

On Tue, Aug 13, 2002 at 01:25:44PM -0300, Luiz Rafael Culik Guimaraes wrote:
> Dear Friend
>
> I searched all postgresql page and didn´t find.
> How to get all tables associated with an Database with C API.
> as Mysql api mysql_list_tables

You'll have to fetch the results of a query like:

select tablename from pg_tables

or

select tablename from pg_tables where not tableowner='postgres'


Adrian Maier
(am@fx.ro)