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 1qJuNA-0005s4-1j for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 11:20:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJuN6-0006yr-Sr for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 11:20:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJuN6-0006yh-Hk for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 11:20:32 +0000 Received: from mr85p00im-zteg06023901.me.com ([17.58.23.192]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qJuMz-000DWc-NP for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 11:20:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mac.com; s=1a1hai; t=1689247222; bh=qDXRxr88+ZuO834+jYxfDI2ZbCm6n0zJsyCTWFDx9mA=; h=From:Content-Type:Mime-Version:Subject:Message-Id:Date:To; b=CP53uzulR8k2w9QTh/qF2XgAWtv6jxvXe6hI3qwelZFdxQRFJhV9Wzfw5BgXWC+qv Si0n48b9zbL2xU2C4962irYWYUaqOX5EDQMl28guQByWbEHWbTr7imllCAs3X6fw5W LMXFuJgmI8X1LC7h1nDN1SU/m8StfUsFhxXYbvg6UoAjJMW6IQESG0nCItcftkXLax 9p9lrsCE4iEVncfp1F0wze3jrYQhWxnZrDs+DgrzbSai6mJ2O7UyaBcV5OA7LKXYNo +ebnkuzFJIRQG4PVRosjQZ4S0O/P+thsEhM79PuTf/qmR0ElRlC6U/IkTcOkPwjy1U UOGbFP0yGqHbg== Received: from smtpclient.apple (mr38p00im-dlb-asmtp-mailmevip.me.com [17.57.152.18]) by mr85p00im-zteg06023901.me.com (Postfix) with ESMTPSA id CE0DF6E0131 for ; Thu, 13 Jul 2023 11:20:21 +0000 (UTC) From: Carl Erik Eriksson Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.600.7\)) Subject: Problem perhaps after upgrading to pgadmin4 7.4 Message-Id: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> Date: Thu, 13 Jul 2023 13:20:03 +0200 To: pgsql-general@lists.postgresql.org X-Mailer: Apple Mail (2.3731.600.7) X-Proofpoint-ORIG-GUID: H1UGPr8qFraKLV8Q_oLZDBQuDEJ2XmZg X-Proofpoint-GUID: H1UGPr8qFraKLV8Q_oLZDBQuDEJ2XmZg X-Proofpoint-Virus-Version: =?UTF-8?Q?vendor=3Dfsecure_engine=3D1.1.170-22c6f66c430a71ce266a39bfe25bc?= =?UTF-8?Q?2903e8d5c8f:6.0.138,18.0.572,17.11.62.513.0000000_definitions?= =?UTF-8?Q?=3D2020-02-14=5F11:2020-02-14=5F02,2020-02-14=5F11,2021-12-02?= =?UTF-8?Q?=5F01_signatures=3D0?= X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 phishscore=0 mlxscore=0 bulkscore=0 adultscore=0 spamscore=0 clxscore=1011 mlxlogscore=588 malwarescore=0 suspectscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2212070000 definitions=main-2307130099 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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=3Drel.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. Any suggestions? Either getting rid of the error message and getting = the output to my screen within the Query tool where I can then dump the = output to a file OR a way of running my query using the PSQL tool and redirecting the = output to a file on my computer. An amateur who is up a creek without any paddle.. Carl E Eriksson=20=