Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XMemG-0005zn-TJ for pgsql-admin@arkaria.postgresql.org; Wed, 27 Aug 2014 15:04:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XMemG-0006SU-DT for pgsql-admin@arkaria.postgresql.org; Wed, 27 Aug 2014 15:04:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XMemF-0006SO-KL for pgsql-admin@postgresql.org; Wed, 27 Aug 2014 15:04:47 +0000 Received: from moh3-ve2.go2.pl ([193.17.41.86] helo=moh3-ve1.go2.pl) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XMem9-0002B0-DT for pgsql-admin@postgresql.org; Wed, 27 Aug 2014 15:04:45 +0000 Received: from moh3-ve1.go2.pl (unknown [10.0.0.157]) by moh3-ve1.go2.pl (Postfix) with ESMTP id 1C46CAF695A for ; Wed, 27 Aug 2014 17:04:35 +0200 (CEST) Received: from o2.pl (unknown [10.0.0.67]) by moh3-ve1.go2.pl (Postfix) with SMTP for ; Wed, 27 Aug 2014 17:04:34 +0200 (CEST) Subject: =?UTF-8?Q?SQL_statement_form_shell_=3F?= From: =?UTF-8?Q?czezz?= To: pgsql-admin@postgresql.org Mime-Version: 1.0 Message-ID: <50235644.468fa51b.53fdf382.a46b@o2.pl> Date: Wed, 27 Aug 2014 17:04:34 +0200 X-Originator: 46.140.133.82 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Im trying to execute simple query in shell.=20 This query works OK in PSQL client:=20 Server4=3D# SELECT * FROM foo2; However, for some reason I cannot execute it in shell. I try it like follow= ing: -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 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin