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 05:31:10
Message-ID: CAOR=d=09VWj0QEWfY+2kRJ6w6p27wfUDQMy1fPLnWcEyB=DvRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 30, 2011 at 11:30 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> But I need to specify a particular database & then fetch tables in that.
>
> Try this, start psql with the -E switch, then run \d and copy and edit
> the query(s) that gives you.

P.s. I think you have to connect to the database you want to pull info
from / about.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2011-08-31 05:38:53 Re: Getting Table Names in a Particular Database
Previous Message Scott Marlowe 2011-08-31 05:30:19 Re: Getting Table Names in a Particular Database