> On Sat, 10 Jan 2004, Eric Freeman wrote:
>
>
>>Is there any way in Postgres to SELECT a list of table names from inside of
>>a C program using ECPG?
>>Something similar to SELECT current_user that will give you all of the
>>tables in the database you are connected to.
>
>
Not sure if this is what you're trying to do but.......
"SELECT tablename FROM pg_tables where tablename not like 'pg_%'"
Will get a list of tables in the db you're connected to.