On Wed, Sep 21, 2011 at 7:54 AM, akp geek <akpg...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
