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@postgresql.org [mailto:pgsql-novice-
> owner@postgresql.org] On Behalf Of M. Bastin
> Sent: Monday, 11 August 2003 11:22 PM
> To: stevemca@optushome.com.au
> Cc: pgsql-novice@postgresql.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
