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.