Re: SQL statement form shell ?

Is the database name correct ?
In your OK execution, database looks to be "Server4" and in other execution
its "fm_db_Server4".

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

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

> 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
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>