COPY TO ... TYPE DELIMITED
>This is probably a simple one for you guys...
>
>I am trying to copy to contents of a table to a type CSV file without including the header line. I tried it with DELIMITED WITH "," and that eliminates the header, but doesn't include the quotes around character types. I need it to be just like the output by the COPY TO filename.txt type CSV where it puts quotes around character fields, and does not with numerics, but I need it to exclude the header.
--sb--