date type changing to timestamp without time zone in postgres 9.4

Поиск
Список
Период
Сортировка
От Rishi Gokhale
Тема date type changing to timestamp without time zone in postgres 9.4
Дата
Msg-id CY1PR0501MB1817CD34825F2DEFE8852461ADB70@CY1PR0501MB1817.namprd05.prod.outlook.com
обсуждение исходный текст
Ответы Re: date type changing to timestamp without time zone in postgres 9.4
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Glen M. Witherington"
Дата:
Сообщение: Re: Efficient sorting the results of a join, without denormalization
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Efficient sorting the results of a join, without denormalization