Problem perhaps after upgrading to pgadmin4 7.4

From: Carl Erik Eriksson <carlerikeriksson(at)mac(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Problem perhaps after upgrading to pgadmin4 7.4
Date: 2023-07-13 11:20:03
Message-ID: 71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

An amateur who is up a creek without any paddle..

Carl E Eriksson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2023-07-13 11:52:05 Re: Problem perhaps after upgrading to pgadmin4 7.4
Previous Message James Tobin 2023-07-13 10:23:34 JOB | DBA (Tokyo)