Is it possible for LC_TIME locale to affect the format with which
timestamps are input?
I have DB2 CSV dumps with timestamps like '2003-10-21-22.59.44.000000'
that I want to load into Postgres with \copy. I would like to eliminate
the sed scripts that convert the timestamps in order to speed up the load.
(I know I could stage it through a temp table and use to_timestamp()
but that requires a temp table for each real table, which is not viable
w.r.t. our project goals).
I created a special locale with the DB2 timestamp format defined and did
set lc_time='en_DB.UTF-8';
It didn't affect anything, in or out with Postgres. I know the locale
works because date(1) displays the DB2 format correctly.
Postgres version: 9.2.2 (Built from source)
OS: Centos 6.3
Paul Jones
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general