On Mon, 2006-02-13 at 15:22, Jim Fu wrote: > Thank you Michael for the info! > > I have the original date info as mmddyy, when I use copy tabname from filename, it fails due to mismatch between raw date info and date data type in the database. It seems like I had to convert the raw date info to be like 'yyyy-mm-dd' to match PostgreSQL date default format in order to use copy command. Take a look here: http://www.postgresql.org/docs/8.1/static/runtime-config-client.html#GUC-DATESTYLE and here: http://www.postgresql.org/docs/8.1/static/datatype-datetime.html
