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 1qJuro-0007n3-Jt for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 11:52:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJurm-0007Uo-DB for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 11:52:14 +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 1qJurm-0007TG-0Z for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 11:52:14 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qJurf-000DmQ-0w for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 11:52:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To: Message-ID:Subject:Cc:To:Sender:From:Date:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=CN6FOmoTKIjNa+30Zom4hOgL/ek0v+6jhJ2bYhJYmWc=; b=lzYNNA6D1L86G5Rwe3DT3BBOvT lTJuEoH3PFn9kYlyzneXF5huMcl/aT/su57PDVEIpyIQ9JyaalGNfI0wGNFZHisqiP72wOndSPgXy yKMbi+ppvaEbYKprmQsrwACSKWKdJ45UkjqTMF84VXb7VWU8azBi32WtXdC1CILx6sy4=; Received: from depesz by depesz.com with local (Exim 4.94.2) (envelope-from ) id 1qJurd-005Ri5-Rk; Thu, 13 Jul 2023 13:52:05 +0200 Date: Thu, 13 Jul 2023 13:52:05 +0200 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: Carl Erik Eriksson Cc: pgsql-general@lists.postgresql.org Subject: Re: Problem perhaps after upgrading to pgadmin4 7.4 Message-ID: Reply-To: depesz@depesz.com References: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 13, 2023 at 01:20:03PM +0200, Carl Erik Eriksson wrote: > 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. > > 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.. Which pg version you're on? Generally, try updating to newest pgadmin, from git repo (https://github.com/pgadmin-org/pgadmin4/), there is/was a bug that caused problems when using pg < 11 : https://github.com/pgadmin-org/pgadmin4/commit/732bcc2b4d91f0126cf69d69c14df199bc4106bc Best regards, depesz