At 05:41 PM 3/16/05, Clay, Bruce wrote:

I have looked through all of the documentation could find and still can not find out how to get names of all tables in a specified DB.

Is there a way through libpq c interface or through a SQL message sent through pqexec to get a list of all of the tables in a given DB?

Do you have access to CLI? Run psql with the -E option to show you the SQL behind any of its commands. Issue the \dt command to list tables. Process the SQL through your favourite interface.