Re: BUG #4002: Error when I attemp to make a query by prompt

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Bill Moran <wmoran(at)collaborativefusion(dot)com> writes:
> In response to "Mario Plazas" <marioplazas(at)gmail(dot)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