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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
