Skip site navigation (1) Skip section navigation (2)

Re: Can't get list of databases with \list

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Frank <c(dot)frank(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Can't get list of databases with \list
Date: 2009-11-02 19:30:01
Message-ID: 7628.1257190201@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Christopher Frank <c(dot)frank(at)gmail(dot)com> writes:
> Issuing a query of "\list" using jdbc doesn't seem to work:

Nope, it won't, because \list is a psql-ism.

If you want to exactly duplicate that you could run psql with -E and
look at the queries it issues and copy them (but beware that they are
backend-version-dependent).  However, I was under the impression that
JDBC had its own set of standard metadata inquiry operations.  You'd
probably be better off using those if they cover what you need.

I'm not sure how many JDBC hackers hang out here; you might be better
advised to ask on the pgsql-jdbc list.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2009-11-02 19:39:09
Subject: Re: Install problems for postgresql-8.4.1
Previous:From: JORGE MALDONADODate: 2009-11-02 19:16:37
Subject: GETTING INFO FROM SEQUENCE OBJECTS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group