Re: copy command - date

I'm using pg version 8.2.4.  What is the best method to load this data?
I have just a little over 55,000 entries.

db5=>  \copy maintenance FROM test.txt
ERROR:  invalid input syntax for integer: "3665   OK           SM
07/07/13 06:09"
CONTEXT:  COPY maintenance, line 1, column maintenance_id: "3665   OK
         SM 07/07/13 06:09"

                                              Table "pm.maintenance"
     Column      |           Type           |
    Modifiers
-----------------+--------------------------+----------------------------------------------------------------------
 maintenance_id  | integer                  | not null default
nextval('maintenance_maintenance_id_seq'::regclass)
 meter_id        | integer                  |
 status          | character(3)             |
 inspector       | character(2)             |
 inspection_date | timestamp with time zone |



On 13/08/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> novice <user.postgresql@gmail.com> writes:
> > I'm having trouble loading the date field.  Should I convert it first
> > or should I be using a text processor before loading the data in?
>
> > 3665   OK           SM 07/07/13 06:09
> > 5162   OK           SM 07/02/12 06:10
> > 3665   OK           SM 07/06/19 06:10
>
> What sort of trouble, exactly?
>
> I'm guessing that you might need to set DateStyle to tell Postgres what
> the date field ordering is, but without seeing any error messages that's
> strictly a guess.
>
>                         regards, tom lane