pgAdmin4 import/export option greyed out

Viewed 19291

so I recently configured and started using Pgadmin 4, managed to set up my localhost database, and my querys work properly, but for some reason I can't use the import/export dialog when I want to export my data as CSV, as it shows as greyed out. Could anyone help me out please? Image for Reference.

EDIT: The "Download as CSV (F8)" button is not working either.

enter image description here

2 Answers

if you are looking to export the query results , you need to do copy

COPY ([Query]) TO '[File Name]' DELIMITER ',' CSV HEADER;

Make sure you have created the file and it has all permissions to access

Related