Re: 'NOW' in UTC with no timezone - Mailing list pgsql-general

From Tom Lane
Subject Re: 'NOW' in UTC with no timezone
Date
Msg-id 27987.1097751403@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'NOW' in UTC with no timezone  (Stuart Bishop <stuart@stuartbishop.net>)
Responses Re: 'NOW' in UTC with no timezone
List pgsql-general
Stuart Bishop <stuart@stuartbishop.net> writes:
> How much overhead is there in storing a timestamp with timezone as
> opposed to one without?

Exactly zero.  You have a misconception about what the datatype really
does --- see other responses in this thread.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: any way to remove a password?
Next
From: Rodrigo Carvalhaes
Date:
Subject: IMPORT FROM CTREE to POSTGRESQL