Re: BUG #4002: Error when I attemp to make a query by prompt - Mailing list pgsql-bugs

Bill Moran <wmoran@collaborativefusion.com> writes:
> In response to "Mario Plazas" <marioplazas@gmail.com>:
>> C:\Archivos de programa\PostgreSQL\8.3\bin>"C:\Archivos de
>> programa\PostgreSQL\8
>> .3\bin\psql.exe" DBASE superpostgres -C "SELECT * FROM companies;"
>> psql: warning: extra command-line argument "-C" ignored
>> psql: warning: extra command-line argument "SELECT * FROM companies;"
>> ignored

> I believe the problem is that you want -c, not -C (case is important).

The other problem is that -c and its argument need to come *before* the
non-switch arguments (database and user name).

>> It works fine on ver. 8.2.4-1 I think that this is a bug for the ver.
>> 8.3.0-1 .

It is not a bug.  Some versions of getopt() happen to be laxer about
argument order than others, but we don't promise that the non-documented
order will work.

            regards, tom lane