Bruce Momjian <[EMAIL PROTECTED]> writes:
> Should we set the datestyle at the top of pg_dump files like we do with
> encoding and other settings? Seems we should.
That was dealt with quite a while back.
regards, tom lane
---(end of broadcast)---
Never mind. I found out that pg_dump already does a SET datestyle =
'ISO' before dumping, so all the dates are in ISO format.
I just need to mention that COPY honors Datesyle.
---
pgman wrote:
> I just found out that dates
I just found out that datestyle affects the output of COPY, and hence
pg_dump:
test=> create table test(x date);
CREATE
test=> insert into test values ('2001-07-31');
INSERT 17239 1
test=> set datestyle to 'postgres, dmy';
SET
test=> copy t
