| From: | Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "B(dot)W(dot)H(dot) van Beest" <bwvb(at)xs4all(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to list which tables are available? |
| Date: | 2003-10-14 19:40:31 |
| Message-ID: | 20031014194031.GC14497@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 14, 2003 at 09:02:13PM +0200, B.W.H. van Beest wrote:
> Thanks for the answers given. I am discovering the world of SQL ...
>
> Given the nature of all replies (they all refer to something that is
> PG-specific), I conclude that there is no generic way (i.e. something
> that will hold for all sql-compliant systems).
Actually, the SQL standard _has_ a way to get this information, called the
INFORMATION_SCHEMA. Not all vendors implement it; at least, it's present
in PostgreSQL 7.4. Meanwhile you can use the pg_tables view.
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Aprende a avergonzarte ms ante ti que ante los dems" (Demcrito)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-10-14 19:54:37 | Re: Excute comnands OS from plpgsql |
| Previous Message | Edwin Quijada | 2003-10-14 19:13:03 | Error compiling pgplsh |