On 5/8/07, Paul Lambert <paul.lambert@autoledgers.com.au> wrote:
> Right now the software that does the extracts is developed by our
> applications developers, but I'll be taking that onto my side in the
> near future, just looking for a workaround until then.
Sorry, but there isn't one. An unqualified COPY expects all columns
and the syntax I gave you is the only way to limit the columns for
insertion.
You could write your own server-side function to parse, split, and
insert the data, but it would be slower than COPY. Likely, the
easiest thing would be to change your company's software.
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/