| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to list which tables are available? |
| Date: | 2003-10-14 21:18:19 |
| Message-ID: | Pine.LNX.4.33.0310141513350.15986-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edwin Quijada | 2003-10-14 21:20:57 | Re: Virtual Machines and postgres |
| Previous Message | Rick Seeger | 2003-10-14 21:11:47 | Re: Char to Int |