James Long <pgsql-novice(at)museum(dot)rain(dot)com> writes:
> james=> \pset fieldsep ,
> Field separator is ",".
> james=> \copy transactions from bar
> psql appears to be treating the entire input line as one tuple,
> instead of seeing the fieldsep value as a field delimiter.
You're confusing psql's output field separator with what COPY will use.
IIRC you need a "delimiter ','" clause on the copy command.
> Also, one issue I can see coming is the date format. Is there
> a way I can read M-D-Y (or M/D/Y) format dates and store them?
See datestyle.
regards, tom lane