Query is executing but giving error when using with shell scripting

From: srilinux <srilinux09(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query is executing but giving error when using with shell scripting
Date: 2017-09-14 15:58:07
Message-ID: 1505404687156-0.post@n3.nabble.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Please suggest what is giving error here
when I execute from psql prompt, I get the result, when I try to automate
using a shell script, the query is not working

# `/usr/bin/psql -U postgres -d coba1 -c "select name from users where
"Date" > current_date - 30;"`
ERROR: column "Date" does not exist
LINE 1: select name from users where Date >current_...

========

works below

^
sudo -u postgres psql

psql (9.4.5)
Type "help" for help.

postgres=# \connect coba1
You are now connected to database "coba1" as user "postgres".
coba1=# select name from users where "Date" >current_date - 30;
name
---------------------
coba11
testCoba11

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-sql-f2142323.html

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2017-09-14 16:21:59 Re: Query is executing but giving error when using with shell scripting
Previous Message Andreas Kretschmer 2017-09-14 01:40:50 Re: How could I improve a query with a function in the join clause?