While trying to export a query result set from PGAdmin4 on PostgreSQL12 to a CSV I am encountering the following error:
ERROR: could not open file "/home/linuxusername/Downloads/data.csv" for reading: Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
SQL state: 42501
I'm somewhat new to PGAdmin but am familiar with Linux and SQL. Is there a configuration setting that I'm unaware of to allow PGAdmin to read and write to files and directories of Linux users?
Using the /tmp works fine, but it's a pain to have to keep moving files to and from other directories and it's seriously cramping my work flow and slowing me down. Any help is much appreciated.
