| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Luiz Rafael Culik Guimaraes <culikr(at)uol(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: list tables |
| Date: | 2002-08-13 01:16:03 |
| Message-ID: | Pine.LNX.4.21.0208130205510.5375-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2002-08-13 01:19:26 | Re: list tables |
| Previous Message | Luiz Rafael Culik Guimaraes | 2002-08-13 01:05:09 | list tables |