In response to "Mario Plazas" <[EMAIL PROTECTED]>: > > The following bug has been logged online: > > Bug reference: 4002 > Logged by: Mario Plazas > Email address: [EMAIL PROTECTED] > 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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
