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

In response to "Mario Plazas" <marioplazas(at)gmail(dot)com>:

>
> The following bug has been logged online:
>
> Bug reference: 4002
> Logged by: Mario Plazas
> Email address: marioplazas(at)gmail(dot)com
> PostgreSQL version: 8.3.0
> Operating system: win xp
> Description: Error when I attemp to make a query by prompt
> Details:
>
> Hi.
> In psql ver 8.3.0, I use a prompt line to connect and query a database. In
> this line, I send the path for execute psql, database and user respectly
> (the password are in a enviroment var); Then, I try to query, but the system
> show the follow error:
>
> 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
> Welcome to psql 8.3.0, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> DBASE=# \q
>
> C:\Archivos de programa\PostgreSQL\8.3\bin>
>
> It works fine on ver. 8.2.4-1 I think that this is a bug for the ver.
> 8.3.0-1 .

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

And it should fail on 8.2 as well, the documentation lists the option
as -c and a quick test here shows similar behaviour if I use -C on
8.2.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023