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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
