Re: How to tell if 64 bit vs 32 bit engine?

On 4月21日, 上午1时35分, pete(dot)(dot)(dot)(at)gmx(dot)net (Peter Eisentraut) wrote:
> Zoltan Boszormenyi wrote:
> > select version();
>
> > It will tell you the compiler version and arch as well. You can deduce
> > from there.
>
> That approach is not reliable. I often build and run a 32-bit build of
> PostgreSQL on a machine that claims to be something like
> x86_64-unknown-linux-gnu.
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

At the client side as libpq, `select version()' is the best solution
now.
It seems a good idea to let the backend support a GUC parameter like
those used in Linux/UNIX.