Re: Getting Table Names in a Particular Database - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Getting Table Names in a Particular Database
Date
Msg-id CAOR=d=1xr7urr1ypVQVHoyJ7MT3DPqVTS7veeKYLaKiG3kHLgQ@mail.gmail.com
Whole thread Raw
In response to Re: Getting Table Names in a Particular Database  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
On Wed, Aug 31, 2011 at 12:10 AM, Adarsh Sharma
<adarsh.sharma@orkash.com> wrote:
> Come back to the original problem. I have 10 databases with different names
> you have to go into the database by \c command to fetch the table names.

Again, in PostgreSQL databases are very separate objects.  In mysql
they are closer to schemas than separate entities.  If you want to
examine a database in pg, you need to connect to it.  period.

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: Getting Table Names in a Particular Database
Next
From: Venkat Balaji
Date:
Subject: Re: Postgresql-9.0.1 Recovery