Im trying to execute simple query in shell.
This query works OK in PSQL client:
Server4=# SELECT * FROM foo2;
However, for some reason I cannot execute it in shell. I try it like following:
-bash-4.1$ psql -p 5472 -d fm_db_Server4 -c "SELECT * FROM foo2;"
ERROR: relation "foo2" does not exist
LINE 1: SELECT * FROM foo2;
^
Any ideas what Im doing wrong ?
BR,
czezz