Re: [GENERAL] Get PG version using JDBC?

2008-10-15 Thread Thomas Kellerer

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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Get PG version using JDBC?

2008-10-15 Thread Rodrigo Gonzalez

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() ?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Get PG version using JDBC?

2008-10-15 Thread Richard Broersma
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 <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Get PG version using JDBC?

2008-10-15 Thread David Wall

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