Обсуждение: psql --csv and other parameters

I don't know if this really is a bug but it seems wrong to me:

psql -A --csv -Xc "select * from pg_namespace order by 1"

gives a difference result than

psql --csv -A -Xc "select * from pg_namespace order by 1"


I would say both should give the same result, and
that result should be the same as from:

psql --csv -Xc "select * from pg_namespace order by 1"


Thanks,

Erik Rijkers

    Erik Rijkers wrote:

> I don't know if this really is a bug but it seems wrong to me:
>
> psql -A --csv -Xc "select * from pg_namespace order by 1"
>
> gives a difference result than
>
> psql --csv -A -Xc "select * from pg_namespace order by 1"

-A and --csv each select an output format, and since
there can be only one output format active, they are
mutually exclusive.

When options conflict, the rightmost on the command line wins,
so -A --cvs is the same as --csv, and --csv -A is the same as -A


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

On Wed, Nov 28, 2018 at 02:38:04PM +0100, Daniel Verite wrote:
> -A and --csv each select an output format, and since
> there can be only one output format active, they are
> mutually exclusive.
>
> When options conflict, the rightmost on the command line wins,
> so -A --cvs is the same as --csv, and --csv -A is the same as -A

And that's what I would expect.  A lot of folks like using aliases and
relying on the last option being defined as a winner instead of bumping
into an error if multiple overlapping options are defined.
--
Michael