Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qK0Vg-0001Gj-GX for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 17:53:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qK0Vd-0005P0-IT for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 17:53:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qK0Vd-0005Or-5G for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 17:53:45 +0000 Received: from mout-u-107.mailbox.org ([2001:67c:2050:101:465::107]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qK0VU-000EHX-Ik for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 17:53:43 +0000 Received: from smtp202.mailbox.org (smtp202.mailbox.org [10.196.197.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4R22K618QKz9sR5; Thu, 13 Jul 2023 19:53:30 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ewie.name; s=MBO0001; t=1689270810; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=oMjZ2EBJNvcZnNgTayaqdmBLUSusbDHICb7neMcR6QQ=; b=2A+DcNuJVFKk+3IN4h5wZ3qv40LptM7ajojvuyASiWhjZdYSxi1/hVitHmkxwo/wkkuwAJ yg1zlSNBJS82lylx/RfipDJiTzUsQqIrtOMHD5R2TFJJFWevDDh6NimmnC1sVnsuU0Fhif oZcuVR7ZmEKsJfDh+1xXmlc4bwat5DopWTGsXIXUY4Cw/ycf81fAqGuaGHr7D/teVqytAs T2Q3pgpRkTaKDLbF2kSai7NEuoQTY72kB6wOiZrNgKx99OZPfG6T7cb2FX5VgczHC3g+Zx TME8+9q+gyOdDmiPnfm3SPqlM5ii00n/TWZ1+YBdb9kbqKV4HAJehfWxahSwNA== Date: Thu, 13 Jul 2023 19:53:29 +0200 (CEST) From: Erik Wienhold To: Carl Erik Eriksson , pgsql-general@lists.postgresql.org Message-ID: <44885323.17430.1689270809619@office.mailbox.org> In-Reply-To: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> References: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> Subject: Re: Problem perhaps after upgrading to pgadmin4 7.4 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 13/07/2023 13:20 CEST Carl Erik Eriksson wrote: > > Query tool PGadmin on my mac > > If I enter a query like select count(*) from table_1 I get a correct > response from the server > If I enter select * from table_1 I get an error message that I do not > understand: > Error Message:missing FROM-clause entry for table "rel" > LINE 8: ...ER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid > > PSQL tool (PGadmin on my Mac) > > However if I enter the same from the PSQL tool I get the correct output. > > But that output goes to my screen and I have found no way of directing it to > a file on my Mac. Redirect the output in psql with meta command \out: \out /path/to/file.txt select * from table_1; > Carl E Eriksson That's a cool name ;) -- Erik