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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Any way to SELECT a list of table names?
Date: 2004-01-11 00:07:08
Message-ID: btq43d$9dd$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jon Jensen 2004-01-11 00:16:58 Re: psql \d option list overloaded
Previous Message Sergey N. Yatskevich 2004-01-10 23:30:43 Probably a security bug in PostgreSQL rule system