Re: list tables Examples - Mailing list pgsql-general

From am@fx.ro
Subject Re: list tables Examples
Date
Msg-id 20020814130151.A221@coto
Whole thread Raw
In response to list tables Examples  ("Luiz Rafael Culik Guimaraes" <culikr@uol.com.br>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: "Mario Weilguni"
Date:
Subject: Re: oid2name reports much fewer files...
Next
From: Christian Mock
Date:
Subject: Re: performance with triggers depends on table size?