Re: copy command - date - Mailing list pgsql-general

From Tom Lane
Subject Re: copy command - date
Date
Msg-id 12012.1186966075@sss.pgh.pa.us
Whole thread Raw
In response to copy command - date  (novice <user.postgresql@gmail.com>)
Responses Re: copy command - date  (novice <user.postgresql@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: novice
Date:
Subject: copy command - date
Next
From: novice
Date:
Subject: Re: copy command - date