Re: -c argument not recognized

On Nov 10, 4:56 pm, thombr(dot)(dot)(dot)(at)gmail(dot)com (Thom Brown) wrote:
> 2009/11/10 Antonio Ruggiero <aruggier(dot)(dot)(dot)(at)gmail(dot)com>:
>
>
>
>
>
> > I am running PostgresSQL 8.3.8 on windows XP-64Bit.  I am using psql
> > client from the PostgreSQL installation and not the Cygwin client.
>
> > My issue is that the command line argument "-c command" is not
> > recognized. For example, if I run (from Cygwin)
>
> > psql -h localhost -p 5432 -d $database postgres -c "select count(*)
> > from  $table_name"
>
> > I receive the following output:
>
> > psql: warning: extra command-line argument "-c" ignored
> > psql: warning: extra command-line argument "select count(*) from
> > $table_name" ignored
> > Welcome to psql 8.3.8, 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
>
> > Warning: Console code page (437) differs from Windows code page (1252)
> >         8-bit characters might not work correctly. See psql reference
> >         page "Notes for Windows users" for details.
>
> > End output.
>
> > If I put the query in a file and run the file from the command line,
> > then it works fine.  Furthermore, it appears I have all the necessary
> > priviledges since I can create/delete/modify tables in the database -
> > as long as the sql code is in a script file.
>
> > I will add that this code runs on an XP-32Bit 8.2 install and I
> > recently installed PostgreSQL on the XP-64Bit machine.
>
> > Thanks for any insight you can provide.
>
> It might be because you're specifying it after the database name which
> should be the last parameter, and which you've already specified with
> -d anyway.  Try: psql -h localhost -p 5432 -d $database -c "select
> count(*)
>
> Regards
>
> Thom
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general- Hide quoted text -
>
> - Show quoted text -

You suggestion did work when I run this

$ psql -h localhost -p 5432 -d $database -c "select count(*) from
client_claim_file" postgres

However, if I now force the username command line argument then I can
recover the original form that worked with 8.2, that is:

>psql -h localhost -p 5432 -d $database -U postgres -c "select count(*) from $tablename"

Thanks for your help - never would have thought about the order of
command line arguments. FYI, the reason I was trying to recover the
original form was that I have an alias for "psql -h localhost -p 5432 -
d $database -U postgres".