Re: psql with option -c fails.. - Mailing list pgsql-general

From akp geek
Subject Re: psql with option -c fails..
Date
Msg-id CACnhOf+aa9L8n41m1AZYmY8oO2zpp5qjQnmPGMu0weoFskpmSg@mail.gmail.com
Whole thread Raw
In response to Re: psql with option -c fails..  (patrick keshishian <pkeshish@gmail.com>)
List pgsql-general
Thanks a lot .. Got it

On Wed, Sep 21, 2011 at 11:01 AM, patrick keshishian <pkeshish@gmail.com> wrote:
On Wed, Sep 21, 2011 at 7:54 AM, akp geek <akpgeek@gmail.com> wrote:
> Hi all -
>                I am trying to run the psql command the following way and
> it's failing . Can you please help?
>                 psql  -d mydb  -c 'update tb_user set accountstatus='A'
> where userid=123'
> ERROR:  column "a" does not exist
> LINE 1: ...date tb_user accountstatus=A

Try:

 psql -d mydb -c "update tb_user set accountstatus='A' where userid=123"

You need to double quotes since you are using single quotes in your SQL string.

--patrick

pgsql-general by date:

Previous
From: patrick keshishian
Date:
Subject: Re: psql with option -c fails..
Next
From: Raymond O'Donnell
Date:
Subject: Re: Storing PHP 5.3 sessions into PostgreSQL 8.4