Re: [GENERAL] Can LC_TIME affect timestamp input?

2013-02-03 Thread Jasen Betts
On 2013-01-28, Paul Jones p...@cmicdo.com wrote: Since posting this, I tried digging around in the source code.  From looking at timestamp_in and related routines, it doesn't appear to take into account any LC_* environment var.  And I didn't see strftime(3) used for timestamps (although I

Re: [GENERAL] Can LC_TIME affect timestamp input?

2013-01-28 Thread Paul Jones
- Original Message - From: Jasen Betts ja...@xnet.co.nz To: pgsql-general@postgresql.org Cc: Sent: Saturday, January 26, 2013 9:00 PM Subject: Re: [GENERAL] Can LC_TIME affect timestamp input? On 2013-01-25, Paul Jones p...@cmicdo.com wrote: Is it possible for LC_TIME locale

Re: [GENERAL] Can LC_TIME affect timestamp input?

2013-01-26 Thread Jasen Betts
On 2013-01-25, Paul Jones p...@cmicdo.com wrote: 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.00' All the non-digit symbols between 21 and the 44 look unusual that I want to load

[GENERAL] Can LC_TIME affect timestamp input?

2013-01-25 Thread Paul Jones
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.00' 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