Re: casting character varying to integer - order by numeric

Bryce Nesbitt (mailing list account) wrote:
> Tom Lane wrote:

>>As a general rule, you need to be more specific than that about which
>>version you are working with ;-)

> Oooh, I'd be so happy to.  But I don't know.  Yes, I don't know.
> 
> I know which version of "psql" is installed on my local machine, but the actual 
> database is remote.  Is there a  command to get the server version?  As close as 
> I can find is:
> 
> stage=> \copyright

SELECT version();

--   Richard Huxton  Archonet Ltd