Обсуждение: 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 PRECISION
>
> timestamps?
>


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:

> 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
>