Can LC_TIME affect timestamp input?

From: Paul Jones <pbj(at)cmicdo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Can LC_TIME affect timestamp input?
Date: 2013-01-25 18:24:45
Message-ID: 1359138285.56820.YahooMailNeo@web122202.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-01-25 18:42:38 Re: Optimizing select count query which often takes over 10 seconds
Previous Message Jeff Janes 2013-01-25 17:58:54 Re: Running update in chunks?