Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLDtO-002byG-BJ for pgsql-general@arkaria.postgresql.org; Mon, 17 Jul 2023 02:23:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qLDtL-003ImF-Ma for pgsql-general@arkaria.postgresql.org; Mon, 17 Jul 2023 02:23:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qLDtL-003Im6-CC for pgsql-general@lists.postgresql.org; Mon, 17 Jul 2023 02:23:15 +0000 Received: from mail-yb1-xb35.google.com ([2607:f8b0:4864:20::b35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qLDtJ-000yGM-89 for pgsql-general@lists.postgresql.org; Mon, 17 Jul 2023 02:23:14 +0000 Received: by mail-yb1-xb35.google.com with SMTP id 3f1490d57ef6-ca9804dc6e4so5763436276.0 for ; Sun, 16 Jul 2023 19:23:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689560591; x=1692152591; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=zXUSZC9m9ljKAfTfiyNVq8xIhVzX5JutJdYYwOoTTk4=; b=fqVEMfuTv1imJLtoOZNAWqJUsrlwjmSi27eIYssDsucKYyhROYkvox911iw1oPQ6qQ IeJ6RoaKoFJMQSnnWpoCa9lQPrHq9CaFZ7YFqxBk7a4ctklFH3epuTF0O9YqdAgPvNR+ kX0NokISEkJXd7undouAiagXsRWnes+ZICrQ3/T2UG5GcKJqny4OePeZIGlXfFhJrw7l tdCWaRirGftvl9rUIUxQlSyG43KkLvabVAQOJvMLc6JzdSp6uSQgpov1QqPfUqgIJVa9 /6NobomV5tekLS8JUeVsFGwfyKPs082J4mh4JylVH4Fy2eksQSdzWKNDOQU2qZlM040s r6qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689560591; x=1692152591; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=zXUSZC9m9ljKAfTfiyNVq8xIhVzX5JutJdYYwOoTTk4=; b=Ojo5IwDHMl2UL5mao1K+orma2ca1S8Ff/2vfWam7mcGnopR59VLEdi77wm7vsMsk1z QrLLnyY5V1m63SOoxqNY1XUeQ1aM6zgm/7FiHspGkh6ppRRYXWgVxS+r9hQgPISaGraI PdmKFRd9Ymb83HUf38jZDX+7FkXrk08QmvL3e9JdY5pMJDS6rjvqcwi2Yz/uVOJWRCm4 mLfQI+TtNjdDUGcEiEOYZys/j0K8sQPXP7xr2wnfgvmgTEc9jVCbcJDuk/tLZeLdAuw5 YLH5QxUjKpY4wvWnZxaHxG9nbyu9BYwR1QduFokDLC80B3BOnKOGoequUHhVKxyPQT8H QLfg== X-Gm-Message-State: ABy/qLaYpn1JcZkDluYBmajNpvOMcEDUhNHVlpe69XJtld84rb+sbHR6 rS0JC7emK2x/Q+owEjvWC+LN5gJd320= X-Google-Smtp-Source: APBJJlHc1+D3VLD2eCdWtZwN6p6Fr/ztLa4jGBZ//3A6B4H6H5/IxbgG7V1xv9IgMceAPHcots5kcQ== X-Received: by 2002:a5b:886:0:b0:c42:53eb:1599 with SMTP id e6-20020a5b0886000000b00c4253eb1599mr10342279ybq.16.1689560590914; Sun, 16 Jul 2023 19:23:10 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:12c:a761:a6b5:6e5c? ([2600:1700:bd2c:b810:12c:a761:a6b5:6e5c]) by smtp.googlemail.com with ESMTPSA id h6-20020a25e206000000b00be865f3d4fdsm2691856ybe.62.2023.07.16.19.23.10 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 16 Jul 2023 19:23:10 -0700 (PDT) Message-ID: Date: Sun, 16 Jul 2023 21:23:10 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Problem perhaps after upgrading to pgadmin4 7.4 Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> From: Ron In-Reply-To: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/13/23 06:20, 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. > > 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. Two other solutions: psql --dbname=foo -c "select * from table_1;" > table_1.txt psql foo --csv -c "select * from table_1;" > table_1.csv -- Born in Arizona, moved to Babylonia.