Re: European date format option

Nigel Gilbert writes:

> The online documentation for SET says:
>
> Running postmaster using the option -o -e to set dates to the
^^^^^^^^^^

> European convention.
>
> but attempting to do this results in:
>
> $ pg_ctl start -o -e
^^^^^^
> postmaster successfully started
> $ /usr/local/pgsql/bin/postmaster: illegal option -- e
> Try '/usr/local/pgsql/bin/postmaster --help' for more information.

> Is this a bug in postmaster or in the documentation? Is there a
> workaround (I need all the dates for all connections to be in
> DD-MM-YYYY format)?

That's not what you're going to get out of it anyway. ("European" is a
much too general term.) It's better not to rely in these settings.
Instead, explicitly format your values using the to_char() function.
(Set up a view or three if needed.)

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter