Re: copy command - date

Thanks again guys =)
I've managed to use temp table to load the data and create new table/s
Now, how do I convert a text field with 'YY/MM/DD' to date field 'DD/MM/YY'?

On 13/08/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> writes:
> >> novice wrote:
> >>> db5=> \copy maintenance FROM test.txt
>
> > I don't think copy allows you to leave columns out of your input file -
> > even if they belong to a sequence.
>
> Well, it does, but you have to specify which ones are being provided,
> eg \copy tab(col1,col4,col7, ...
>
> But the long and the short of it is that COPY doesn't see any column
> delimiters at all in this file. We're guessing as to what the OP
> intends the columns to be, but whatever he wants, he needs something
> other than an uncertain number of spaces to separate them ...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>