Обсуждение: 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