Re: getting PostgreSQL version from TCP/IP client

The version() function and others is explained in the Postgres
Documentation under Functions and Operators/Miscellaneous functions. The
use (misuse) of the missing FROM clause is also explained in the
documentation under SQL Commands/Select

Hope this helps

Steve McAllister

> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-
> owner(at)postgresql(dot)org] On Behalf Of M. Bastin
> Sent: Monday, 11 August 2003 11:22 PM
> To: stevemca(at)optushome(dot)com(dot)au
> Cc: pgsql-novice(at)postgresql(dot)org
> Subject: Re: [NOVICE] getting PostgreSQL version from TCP/IP client
>
> Thanks Steve, it works. Are there any other things working with
> SELECT like this -- or better, where is this documented?
>
> Thanks,
>
> Marc
>
> >Select version();
> >
> > > I couldn't find a command to get the version number of PostgreSQL
> > > from a TCP/IP client. How must I do this?
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings