Re: How to list which tables are available?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to list which tables are available?
Date: 2003-10-14 20:07:44
Message-ID: 1066162064.12390.47.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

> B.W.H. van Beest wrote:
> > It seems so elementary, but how I get a list of which tables are
> > available in a database. I can't find an SQL command for this, but there
> > must be a way!
> >
> > Thanks.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA

"As I like to joke, I may have invented it, but Microsoft made it
popular"
David Bradley, regarding Ctrl-Alt-Del

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CoL 2003-10-14 20:15:07 Re: Excute comnands OS from plpgsql
Previous Message scott.marlowe 2003-10-14 19:54:37 Re: Excute comnands OS from plpgsql