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

Reply via email to