timestamp configuration
is there anyway with a running instance of postgres to find out if it was compiled with:
BIGINT
vs
DOUBLE PRECISION
timestamps?
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
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 PRECISIONtimestamps?
SHOW INTEGER_DATETIMES;
Osvaldo
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:Show quoted text
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 PRECISIONtimestamps?
SHOW INTEGER_DATETIMES;
Osvaldo