Re: [E] Re: CSV From Oracle with timestamp column getting errors

2021-03-22 Thread Saha, Sushanta K
Awesome. Thanks Victor! Sushanta On Mon, Mar 22, 2021 at 4:47 PM Victor Yegorov wrote: > пн, 22 мар. 2021 г. в 21:38, Saha, Sushanta K < > sushanta.s...@verizonwireless.com>: > >> \COPY table1 FROM '/tmp/Oracle_2020_06.csv' DELIMITER ',' CSV HEADER; >> ERROR: invalid input syntax for typ

Re: CSV From Oracle with timestamp column getting errors

2021-03-22 Thread Tim Cross
"Saha, Sushanta K" writes: > \COPY table1 FROM '/tmp/Oracle_2020_06.csv' DELIMITER ',' CSV HEADER; > ERROR: invalid input syntax for type timestamp: "01-JUN-20 06.04.20.634000 > AM" > CONTEXT: COPY table1, line 2, column last_update_timestamp: "01-JUN-20 > 06.04.20.634000 AM" > The problem

Re: CSV From Oracle with timestamp column getting errors

2021-03-22 Thread Victor Yegorov
пн, 22 мар. 2021 г. в 21:38, Saha, Sushanta K < sushanta.s...@verizonwireless.com>: > \COPY table1 FROM '/tmp/Oracle_2020_06.csv' DELIMITER ',' CSV HEADER; > ERROR: invalid input syntax for type timestamp: "01-JUN-20 > 06.04.20.634000 AM" > CONTEXT: COPY table1, line 2, column last_update_timest

Re: CSV From Oracle with timestamp column getting errors

2021-03-22 Thread Saha, Sushanta K
The table column definition: Column | Type | ---++ last_update_timestamp | timestamp(6) without time zone | Thanks & Regards Sushanta On Mon, Mar 22, 2021 at 4:37 PM Saha, Sushanta K

CSV From Oracle with timestamp column getting errors

2021-03-22 Thread Saha, Sushanta K
\COPY table1 FROM '/tmp/Oracle_2020_06.csv' DELIMITER ',' CSV HEADER; ERROR: invalid input syntax for type timestamp: "01-JUN-20 06.04.20.634000 AM" CONTEXT: COPY table1, line 2, column last_update_timestamp: "01-JUN-20 06.04.20.634000 AM" Appreciate any help with this psql command. Thanks & Re