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