Re: psql patch for datestyle - Mailing list pgsql-patches

From Tom Lane
Subject Re: psql patch for datestyle
Date
Msg-id 6405.1046701963@sss.pgh.pa.us
Whole thread Raw
In response to psql patch for datestyle  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: psql patch for datestyle  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-patches
Oliver Elphick <olly@lfix.co.uk> writes:
> This patch sets DATESTYLE to ISO at the start of a pg_dump, so that the
> dates written into the dump will be restorable onto any database,
> regardless of how its default datestyle is set.

I have forgotten: will an ISO-style date be read in correctly regardless
of the datestyle setting at load time?  Or do we need to make pg_dump
issue SET DATESTYLE in the dump script as well?

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_autovacuum (pg_avd version 2)
Next
From: Oliver Elphick
Date:
Subject: Re: psql patch for datestyle