I have a big ascii text file that I would only like to import columns 1, 3 and 7 from. I know I can filter it through cut, but I wonder if there is an undocumented way to do it with COPY. Sybase has a useless function called filler() that you use for fields you want to ignore. For example (psuedocode...)
COPY mytable (col1, filler(), filler(), col2, filler(), col3) FROM '/tmp/foobar'; I like the new functionality allowing me to ignore columns in the target table, and to rearrange the columns, but this functionality seems to be missing... (Or I am reading it wrong...) Thanks! Ian Harding Programmer/Analyst II Tacoma-Pierce County Health Department [EMAIL PROTECTED] Phone: (253) 798-3549 Pager: (253) 754-0002 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
