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
whereI 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