Re: Determing Postgres version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Try:

select version();

Chirs

> -----Original Message-----
> From: pgsql-php-owner@xxxxxxxxxxxxxx
> [mailto:pgsql-php-owner@xxxxxxxxxxxxxx]On Behalf Of Gary Hoffman
> Sent: Monday, 17 December 2001 2:24 PM
> To: pgsql-php@xxxxxxxxxxxxxx
> Subject: [PHP] Determing Postgres version
>
>
> For an off-campus project, my web hosting ISP has the PostgreSQL
> postmaster running on a host separate from where my web pages are hosted.
> My queries work OK, but I can't get LIMIT to work. I suspect he hasn't
> upgraded to version 7 yet. How can I query for a version? I can't use
> pg_config --version because it's not on my local host and anyway it
> wouldn't find the postmaster on this host.
>
> Can I use a SQL query to determine the version of the postmaster?
>
> Thanks in advance.
> Gary
>
> **************************************************************************
> * Gary B. Hoffman, Computing Services Manager  e-mail: ghoffman@xxxxxxxx *
> * Graduate School of International Relations and Pacific Studies (IR/PS) *
> * University of California, San Diego (UCSD)       voice: (858) 534-1989 *
> * 9500 Gilman Dr. MC 0519                            fax: (858) 534-3939 *
> * La Jolla, CA 92093-0519 USA             web: http://www-irps.ucsd.edu/ *
> **************************************************************************
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
>



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux