From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Elinor Medezinski <elinor(at)bellatrix(dot)tau(dot)ac(dot)il> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: help with COPY query |
Date: | 2004-02-29 04:00:56 |
Message-ID: | 12493.1078027256@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Elinor Medezinski <elinor(at)bellatrix(dot)tau(dot)ac(dot)il> writes:
> I want to load a file containning a column of FLOATS, into a table of
> INTEGERs.
> ...
> How can I go around this problem? is there any way to force copy to do the
> right casting?
COPY is not designed to do data manipulation for you. The best bet is
to load the data file into a temp table that has a column set matching
the data file, and then use INSERT ... SELECT to transform the data
and insert it into the final table.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 2004-02-29 06:07:11 | Re: Cannot insert a duplicate key into unique index |
Previous Message | Bruce Momjian | 2004-02-29 01:13:30 | Re: Compilation issue with --enable-thread-safety |