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.