"mike" <matrix@quadrent.net> writes:
> I'm trying to reset my datestyle which works till I have to log out and log=
> back into my shell.
> the docs have nothign in them ast to how to keep the datestyle set. is this=
> somethign that can
> be done once, or does it have to be done every single time?
It ought to be possible to set datestyle in postgresql.conf, but AFAICS
it's not at the moment. (Hey Peter, couldn't the special cases in
SetPGVariable be handled in guc.c instead?)
In the meantime, try starting the postmaster with environment variable
PGDATESTYLE set.
regards, tom lane