Re: Any way to SELECT a list of table names?

Eric Freeman schrieb:
> 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.
>

I guess you are looking for the information stored in pg_tables:

http://www.postgresql.org/docs/current/static/view-pg-tables.html

Thomas