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@gmx.net http://funkturm.homeip.net/~peter