Use the \copy meta-command in the psql terminal to save files locally.
SELECT column1, column2, column3 INTO OUTFILE '/var/lib/mysql-files/output.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM your_table; Use code with caution. Key Parameters Broken Down sql query to download file
This command saves the file directly onto the database server hosting environment. Use the \copy meta-command in the psql terminal
COPY (SELECT id, name, email FROM users) TO '/tmp/users_export.csv' WITH CSV HEADER DELIMITER ','; Use code with caution. Client-Side Export (No Superuser Required) sql query to download file
Attackers can read or write sensitive system files.