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