Re: Getting Table Names in a Particular Database

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting Table Names in a Particular Database
Date: 2011-08-31 06:12:33
Message-ID: CAOR=d=1xr7urr1ypVQVHoyJ7MT3DPqVTS7veeKYLaKiG3kHLgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 31, 2011 at 12:10 AM, Adarsh Sharma
<adarsh(dot)sharma(at)orkash(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Venkat Balaji 2011-08-31 06:40:36 Re: Postgresql-9.0.1 Recovery
Previous Message Adarsh Sharma 2011-08-31 06:10:07 Re: Getting Table Names in a Particular Database