From: | Rishi Gokhale <rgokhale(at)bjondinc(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | date type changing to timestamp without time zone in postgres 9.4 |
Date: | 2015-05-31 05:05:17 |
Message-ID: | CY1PR0501MB1817CD34825F2DEFE8852461ADB70@CY1PR0501MB1817.namprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
When I create a table with a column whose type is date the type gets forced to timestamp without timezone after it gets created
ops=# CREATE TABLE test (
ops(# name varchar(40) NOT NULL,
ops(# start date NOT NULL
ops(# );
CREATE TABLE
ops=# \d test;
Table "public.test"
Column | Type | Modifiers
--------+-----------------------------+-----------
name | character varying(40) | not null
start | timestamp without time zone | not null
ops=#
The table creation is just a test, my original issue is while restoring a backup (pg_dump/pg_restore) from another server also 9.4, where the date types on numerous columns get forced to change to timestamp without timezone.
Any help would be appreciated.
Thanks,
Rishi
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-05-31 05:53:37 | Re: Efficient sorting the results of a join, without denormalization |
Previous Message | Glen M. Witherington | 2015-05-31 04:43:25 | Re: Efficient sorting the results of a join, without denormalization |