Re: list tables

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