From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | Carl Erik Eriksson <carlerikeriksson(at)mac(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Problem perhaps after upgrading to pgadmin4 7.4 |
Date: | 2023-07-13 17:53:29 |
Message-ID: | 44885323.17430.1689270809619@office.mailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 13/07/2023 13:20 CEST Carl Erik Eriksson <carlerikeriksson(at)mac(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2023-07-13 20:50:15 | Re: "PANIC: could not open critical system index 2662" - twice |
Previous Message | Carl Erik Eriksson | 2023-07-13 13:48:53 | Re: Problem perhaps after upgrading to pgadmin4 7.4 |