Thread: Get PG version using JDBC?
Is there a way to get the PG version string from JDBC? I'm using PG 8.3. Thanks, David
Select version();
version
-----------------------------------------------------
PostgreSQL 8.3.3, compiled by Visual C++ build 1400
(1 row)
On Wed, Oct 15, 2008 at 2:01 PM, David Wall <d.wall@computer.org> wrote:
> Is there a way to get the PG version string from JDBC? I'm using PG 8.3.
>
> Thanks,
> David
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
David Wall wrote: > Is there a way to get the PG version string from JDBC? I'm using PG 8.3. > > Thanks, > David > SELECT version() ?
David Wall wrote on 15.10.2008 23:01: > Is there a way to get the PG version string from JDBC? I'm using PG 8.3. > > Thanks, > David > In a portable manner: http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getDatabaseProductName() http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getDatabaseProductVersion() Althout that will not return the information "compiled by..." as the suggested "select version()" does Thomas