[HACKERS] Re: [QUESTIONS] SET DateStyle

>
> > how do you set the European datestyle permanently in PostgreSQL?
>
> For a _really_ permanent default setting, you could edit
> src/backend/utils/init/globals.c and change the initial value of
> EuroDates from "false" to "true".
>
> The suggestion you have already gotten, to specify "-o -e" on the
> command line, is probably better since you don't have to modify source
> code when updating software.
>
> We might consider having it be an installation option; will bring it up
> with the developers...

I think what we have now it fine.  I always start the postmaster from a
script, and you can put whatever customization you want in there,
including -e.  I recommend others do the same.

However, I don't believe we have flags for the other date output formats.

- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------