Postgres Pro
Downloads
Home   >   mailing lists

table listing queries - Mailing list pgsql-sql

From Daniel Silverstone
Subject table listing queries
Date
Msg-id 1124968435.18119.1.camel@petitemort.i.digital-scurf.org
Whole thread Raw
Responses Re: table listing queries  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Number of rows in a cursor ?
Next
From: Sean Davis
Date:
Subject: Re: table listing queries