CREATE SEQUENCE testseq; CREATE TABLE testtimezone_target ( id bigint DEFAULT nextval('testseq'::regclass), timestamp_timestamp timestamp without time zone, timestamp_string character varying(30) ); COPY testtimezone_target (id, timestamp_timestamp, timestamp_string) FROM stdin; 15000000012 2007-03-25 00:30:00 25.03.2007 00:30:00 15000000013 2007-03-25 01:30:00 25.03.2007 01:30:00 15000000014 2007-03-25 02:30:00 25.03.2007 02:30:00 15000000015 2007-03-25 03:30:00 25.03.2007 03:30:00 15000000016 2007-03-25 04:30:00 25.03.2007 04:30:00 15000000017 2007-10-27 22:30:00 27.10.2007 22:30:00 15000000018 2007-10-27 23:30:00 27.10.2007 23:30:00 15000000019 2007-10-28 00:30:00 28.10.2007 00:30:00 15000000020 2007-10-28 01:30:00 28.10.2007 01:30:00 15000000021 2007-10-28 02:30:00 28.10.2007 02:30:00 15000000022 2007-10-28 03:30:00 28.10.2007 03:30:00 15000000023 2007-10-28 04:30:00 28.10.2007 04:30:00 \.