On Feb 3, 2011, at 8:14 AM, Rich Shepard wrote:
> One column in a table has the data type DATE. Do I need to wrap the date
> in single quotes in the .csv file before importing those rows into the
> table? Dates in the table are not quoted.
Not if you're using COPY, no. To see what format you need in the CSV, try creating a few rows and then exporting them
COPY mytable TO STDOUT CSV;
Best,
David