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 <[email protected]> wrote: > From: Osvaldo Kussama <[email protected]> > Subject: Re: [GENERAL] timestamp configuration > To: "Dennis Gearon" <[email protected]> > Cc: [email protected] > Date: Monday, May 24, 2010, 9:02 PM > 2010/5/25 Dennis Gearon <[email protected]>: > > 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 > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
