Re: list tables - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: list tables
Date
Msg-id Pine.LNX.4.21.0208130205510.5375-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to list tables  ("Luiz Rafael Culik Guimaraes" <culikr@uol.com.br>)
Responses Re: list tables  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
On Mon, 12 Aug 2002, Luiz Rafael Culik Guimaraes wrote:

> Dear Friends
>
> How to get all tables associated with an database via C api
>

You can get the query using the psql command line based interface by invoking
it with the extra options: -E -l

Or you could use: SELECT * FROM pg_database

To find out the C API you could read the PERL manpage, man Pg, and use the
header file .../include/libpq-fe.h to match the PERL names/descriptions to the
C functions. Alternatively, I think there is section in one of the HTML
documents found through .../doc/html/index.html that describes the C API.


--
Nigel J. Andrews
Telephone: +44 (0) 208 941 1136




pgsql-general by date:

Previous
From: "Luiz Rafael Culik Guimaraes"
Date:
Subject: list tables
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: list tables