Re: import CSV file - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: import CSV file
Date
Msg-id 20070314155844.GC8944@phlogiston.dyndns.org
Whole thread Raw
In response to Re: import CSV file  (T E Schmitz <mailreg@numerixtechnology.de>)
List pgsql-sql
On Tue, Mar 13, 2007 at 11:52:17PM +0000, T E Schmitz wrote:
> Also, it's nopt happy about the date format : 2007/02/09

You may need to fiddle with your date style.  It works for me on 8.1:

SELECT '2007/02/09'::date;   date    
------------2007-02-09
(1 row)


A
-- 
Andrew Sullivan  | ajs@crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?    --attr. John Maynard Keynes


pgsql-sql by date:

Previous
From: "Pablo Barrón"
Date:
Subject: ordering by multiple columns
Next
From: Andreas Kretschmer
Date:
Subject: Re: ordering by multiple columns