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@xxxxxxxxx> wrote: > From: Osvaldo Kussama <osvaldo.kussama@xxxxxxxxx> > Subject: Re: timestamp configuration > To: "Dennis Gearon" <gearond@xxxxxxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Date: Monday, May 24, 2010, 9:02 PM > 2010/5/25 Dennis Gearon <gearond@xxxxxxxxxxxxx>: > > 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
