1 year ago
#381662
Micheal Omojola
How can I grant PostgerSQL access to export a file to my desired path?
I've been trying to export a table to my Ubuntu Desktop using the following command:
\copy stock to /home/micheal/Desktop/myCSV.csv CSV HEADER
I get the following error: /home/micheal/Desktop/myCSV.csv: Permission denied
How can I grant permission to save this file? I don't want to save in the '/temp/' directory.
postgresql
export-to-csv
file-permissions
0 Answers
Your Answer