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 HE
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, Sushan
\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
You can explore "pgloader" also.
Sushanta
On Tue, Aug 25, 2020 at 7:24 AM Peter J. Holzer wrote:
> On 2020-08-24 21:17:36 +, Dirk Krautschick wrote:
> > what would be the fastest or most effective way to load few (5-10) TB
> > of data from flat files into a postgresql database, includ
