Re: copy command - date

From: "Raj A" <raj(dot)ayappan(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: copy command - date
Date: 2007-08-13 03:23:17
Message-ID: ddcb1c340708122023v3e457b9fjf861480235064c2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message novice 2007-08-13 03:28:51 Re: copy command - date
Previous Message Tom Lane 2007-08-13 02:33:05 Re: copy command - date