> On 13/07/2023 13:20 CEST Carl Erik Eriksson <carlerikeriks...@mac.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


Reply via email to