Postgres Pro
Downloads
Home   >   mailing lists

Re: Any way to SELECT a list of table names? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Any way to SELECT a list of table names?
Date
Msg-id btq43d$9dd$1@sea.gmane.org
Whole thread Raw
In response to Any way to SELECT a list of table names?  ("Eric Freeman" <ejf7@hotmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Eric Freeman"
Date:
Subject: Any way to SELECT a list of table names?
Next
From: Igor Shevchenko
Date:
Subject: psql's "\d" and CLUSTER