Re: SQL statement form shell ?

On Wed, Aug 27, 2014 at 8:53 PM, czezz <czezz(at)o2(dot)pl> wrote:

> Copy/Paste error. DB name should be: fm_db_Server4
>
>
> ​
​Did you set
PGOPTIONS environment variable for that terminal for any specific schema
which do not contain the table "foo"
​. Then you might hit the error

-bash-4.1$ export PGOPTIONS="-c search_path=tester"
-bash-4.1$ psql -p 5432 -d postgres -c "SELECT * FROM foo;"
ERROR: relation "foo" does not exist
LINE 1: SELECT * FROM foo;
^
​
​---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

>
> Dnia 27 sierpnia 2014 17:13 Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
> napisał(a):
>
> fm_db_Server4
>
>
>
>