On Tue, Aug 30, 2011 at 11:30 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general