Re: SQL statement form shell ?

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

 




On Wed, Aug 27, 2014 at 8:53 PM, czezz <czezz@xxxxx> 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

 

Dnia 27 sierpnia 2014 17:13 Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> napisał(a):

fm_db_Server4




[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