COPY and custom datestyles. Or some other technique?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: COPY and custom datestyles. Or some other technique?
Date: 2023-03-29 23:24:36
Message-ID: c1b6aa5b-61ca-1ab6-6295-172fbc0f6c21@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgresql 13.10

$ psql -h myhost.example.com -X dba \
        -c "\copy ${tbl} from '/var/lib/pgsql/Rdb/${tbl}.csv' WITH
DELIMITER '|';"
ERROR:  date/time field value out of range: "2013061914122501"
CONTEXT:  COPY t_id_master, line 1, column update_timestamp: "2013061914122501"

The timestamp format generated by a legacy dbms is YYYYMMDDHHmmSSCC (year to
centisecond, with no delimiters).

Is there any way to convince Postgresql to import these fields?

There are 550+ tables, so something that I can do once on this end would
make my life a lot easier.

--
Born in Arizona, moved to Babylonia.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-03-29 23:31:21 Re: COPY and custom datestyles. Or some other technique?
Previous Message Andrey Klochkov 2023-03-29 21:03:29 Re: Do BRIN indexes support MIN/MAX?