Re: import CSV file - Mailing list pgsql-sql

On 3/13/07, T E Schmitz <mailreg@numerixtechnology.de> wrote:
> This is pretty ingenious!
> Just a few minor problems:
> - how does COPY know which column is which?
> - how do I specify DELIMITER as TAB?

See:
http://www.postgresql.org/docs/8.2/static/sql-copy.html

> Also, it's nopt happy about the date format : 2007/02/09

See:
http://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-DATESTYLE