for those walking up to a new server and who want to know the same information:
shell script invoked by:
script_filename database user
#!/bin/sh
psql -c "show INTEGER_DATETIMES;" -d $1 -U $2 -W
Dennis Gearon
Signature Warning
----------------
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--- On Mon, 5/24/10, Osvaldo Kussama <osvaldo.kussama@gmail.com> wrote:
> From: Osvaldo Kussama <osvaldo.kussama@gmail.com>
> Subject: Re: [GENERAL] timestamp configuration
> To: "Dennis Gearon" <gearond@sbcglobal.net>
> Cc: pgsql-general@postgresql.org
> Date: Monday, May 24, 2010, 9:02 PM
> 2010/5/25 Dennis Gearon <gearond@sbcglobal.net>:
> > is there anyway with a running instance of postgres to
> find out if it was compiled with:
> >
> > BIGINT
> > vs
> > DOUBLE PRECISION
> >
> > timestamps?
> >
>
>
> SHOW INTEGER_DATETIMES;
>
> Osvaldo
>