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 |