Postgres Pro
Downloads
Home   >   mailing lists

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=09VWj0QEWfY+2kRJ6w6p27wfUDQMy1fPLnWcEyB=DvRg@mail.gmail.com
Whole thread Raw
In response to Re: Getting Table Names in a Particular Database  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
On Tue, Aug 30, 2011 at 11:30 PM, Scott Marlowe <scott.marlowe@gmail.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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Getting Table Names in a Particular Database
Next
From: Adarsh Sharma
Date:
Subject: Re: Getting Table Names in a Particular Database