Re: How to list which tables are available? - Mailing list pgsql-general

From scott.marlowe
Subject Re: How to list which tables are available?
Date
Msg-id Pine.LNX.4.33.0310141513350.15986-100000@css120.ihs.com
Whole thread Raw
In response to Re: How to list which tables are available?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On Tue, 14 Oct 2003, Ron Johnson wrote:

> On Tue, 2003-10-14 at 14:02, 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).
> >
> > Is that correct, and moreover, what could be the reason that such an
> > listing function is not "standard" sql?
>
> This operation is not, to my knowledge, specified by The Standard.
>
> Thus, it's implementation-specific.

Actually, as of 7.4 we implement the spec standard information_schema,
which is the spec way of doing it.  It's just fairly new, so most
databases probably don't support it yet.


pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Re: Virtual Machines and postgres
Next
From: Ron Johnson
Date:
Subject: Re: Char to Int