Thread: -U option in psql

-U option in psql

From
"Jaime Casanova"
Date:
Hi,

In 8.3.0 (windows installation) if I execute this command i get an
error while in 8.2 i get a psql command prompt, is this a change in
behaviour or a bug?

H:\Archivos de programa\PostgreSQL\8.3\bin>psql template1 -U postgres
psql: warning: extra command-line argument "postgres" ignored
Password for user -U:
psql: fe_sendauth: no password supplied

-- 
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."                                      Richard Cook


Re: -U option in psql

From
Tom Lane
Date:
"Jaime Casanova" <systemguards@gmail.com> writes:
> In 8.3.0 (windows installation) if I execute this command i get an
> error while in 8.2 i get a psql command prompt, is this a change in
> behaviour or a bug?

> H:\Archivos de programa\PostgreSQL\8.3\bin>psql template1 -U postgres
> psql: warning: extra command-line argument "postgres" ignored

Putting switches after non-switch arguments has never been supported.
On some platforms it works ... sometimes.
        regards, tom lane