On 5/8/07, Paul Lambert <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ---------------------------(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
