Re: SQL statement form shell ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


On Wed, Aug 27, 2014 at 8:34 PM, czezz <czezz@xxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux