Re: timestamp configuration

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(dot)kussama(at)gmail(dot)com> wrote:

> From: Osvaldo Kussama <osvaldo(dot)kussama(at)gmail(dot)com>
> Subject: Re: [GENERAL] timestamp configuration
> To: "Dennis Gearon" <gearond(at)sbcglobal(dot)net>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Monday, May 24, 2010, 9:02 PM
> 2010/5/25 Dennis Gearon <gearond(at)sbcglobal(dot)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
>