>I'm trying to generate a file so someone else can import it.
>
>Needs:
>1. No quotes around character files
>2. delimited with a | (pipe character)
>3. headers (column names) in 1st row.
>
>I can't seem to pull this off -- anyone know the syntax?
>
>This is close but no header names
>COPY TO (lcoutfile) DELIMITED WITH CHARACTER | WITH ""
>
>..and of course this doesn't work at all lol
>COPY TO (lcoutfile) DELIMITED WITH CHARACTER | WITH "" TYPE CSV

I spent some time with using COPY TO with this and flunked out.
I could write a SCAN that would do this in less time than all the time I wasted with COPY TO but that's no fun, is it?
If you figure it out, lets us know how you did it,