Postgres Pro
Downloads
Home   >   mailing lists

CSV From Oracle with timestamp column getting errors - Mailing list pgsql-general

From Saha, Sushanta K
Subject CSV From Oracle with timestamp column getting errors
Date
Msg-id CAHty+vNygE5705DOE=AMk0uti=4MSbG61FErZFLMP-LJqvCW_w@mail.gmail.com
Whole thread Raw
Responses Re: CSV From Oracle with timestamp column getting errors
Re: CSV From Oracle with timestamp column getting errors
Re: CSV From Oracle with timestamp column getting errors
List pgsql-general
Tree view
\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 & Regards
.... Sushanta

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: design partioning scheme for selecting from latest partition
Next
From: "Saha, Sushanta K"
Date:
Subject: Re: CSV From Oracle with timestamp column getting errors