Re: list tables Examples

From: am(at)fx(dot)ro
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: list tables Examples
Date: 2002-08-14 10:01:51
Message-ID: 20020814130151.A221@coto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fx(dot)ro)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Mock 2002-08-14 10:29:46 Re: performance with triggers depends on table size?
Previous Message Mario Weilguni 2002-08-14 08:01:17 Re: oid2name reports much fewer files...