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