pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtable listing queries
3+ messages / 3 participants
[nested] [flat]
* table listing queries
@ 2005-08-25 11:13 Daniel Silverstone <dsilvers@digital-scurf.org>
0 siblings, 2 replies; 3+ messages in thread
From: Daniel Silverstone @ 2005-08-25 11:13 UTC (permalink / raw)
To: pgsql-sql
Hi,
I know that questions like this have been asked in the past, but I can
find no definitive answer to one particular part of my problem...
Namely, in MySQL I can say: "SHOW TABLES FROM 'dbname'" to list tables
in a database I'm not currently connected to.
I can find no way of doing this in PgSQL.
Is there a way, or is postgres not letting me list the tables until I
have connected to the database for security reasons?
Thanks in advance,
D.
--
Daniel Silverstone http://www.digital-scurf.org/
PGP mail accepted and encouraged. Key Id: 2BC8 4016 2068 7895
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: table listing queries
@ 2005-08-25 11:27 Sean Davis <sdavis2@mail.nih.gov>
parent: Daniel Silverstone <dsilvers@digital-scurf.org>
1 sibling, 0 replies; 3+ messages in thread
From: Sean Davis @ 2005-08-25 11:27 UTC (permalink / raw)
To: Daniel Silverstone <dsilvers@digital-scurf.org>; pgsql-sql
On 8/25/05 7:13 AM, "Daniel Silverstone" <dsilvers@digital-scurf.org> wrote:
> Hi,
>
> I know that questions like this have been asked in the past, but I can
> find no definitive answer to one particular part of my problem...
>
> Namely, in MySQL I can say: "SHOW TABLES FROM 'dbname'" to list tables
> in a database I'm not currently connected to.
>
> I can find no way of doing this in PgSQL.
>
> Is there a way, or is postgres not letting me list the tables until I
> have connected to the database for security reasons?
There are system catalogs which contain the information about tables.
http://www.postgresql.org/docs/8.0/interactive/catalogs.html
However, they are specific to each database. In other words, the storage of
database-specific information is all WITHIN the given database, so you need
to be physically accessing the given database to even see those tables (or
do the query).
Sean
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: table listing queries
@ 2005-08-25 12:16 Hélder M. Vieira <hmv@mail.telepac.pt>
parent: Daniel Silverstone <dsilvers@digital-scurf.org>
1 sibling, 0 replies; 3+ messages in thread
From: Hélder M. Vieira @ 2005-08-25 12:16 UTC (permalink / raw)
To: pgsql-sql
> Namely, in MySQL I can say: "SHOW TABLES FROM 'dbname'" to list tables
> in a database I'm not currently connected to.
In MySQL, table definitions are replicated outside the database files, and
might therefore be available without connecting to a specifc database.
This probably happens because of the need for some kind of unified
repository of objects pertaining to different database engines.
Helder M. Vieira
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-08-25 12:16 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-25 11:13 table listing queries Daniel Silverstone <dsilvers@digital-scurf.org>
2005-08-25 11:27 ` Sean Davis <sdavis2@mail.nih.gov>
2005-08-25 12:16 ` Hélder M. Vieira <hmv@mail.telepac.pt>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox