Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql with option -c fails..

psql with option -c fails..

From
akp geek
Date:
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

Re: psql with option -c fails..

From
Lonni J Friedman
Date:
You can't enclose the query in single quotes and then also use single
quotes inside the query.  Either escape the quotes inside the query,
or enclose the query in double quotes.

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
>
> Thanks for the help
> Regards



--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       https://netllama.linux-sxs.org

Re: psql with option -c fails..

From
patrick keshishian
Date:
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

Re: psql with option -c fails..

From
akp geek
Date:
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