psql with option -c fails..

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: psql with option -c fails..
Date: 2011-09-21 14:54:48
Message-ID: CACnhOf+pFufp09Ec+EKxcjq-5vMkoKvQyMX4UdiBbdmi+gm63A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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*
*
*

Thanks for the help

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2011-09-21 14:59:10 Re: psql with option -c fails..
Previous Message Alexander Farber 2011-09-21 14:53:56 Storing PHP 5.3 sessions into PostgreSQL 8.4