pgAdmin4 import/export option greyed out

Question

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.

score 6 · Accepted Answer · answered May 12 '17 at 16:29

6

You can just right click the table and use Import/Export option.

OR

To make Import/Export option you need to select table then click on Tools => Import/Export

And CSV download button is not working on some platform in current version that's a bug and already reported, It'll be fixed in next release.

answered May 12 '17 at 16:29

Murtuza Z

5,639
1
28
52

What if I want to export a specific query as csv and not the whole table? – Omaruchan May 12 '17 at 16:35
pgAdmin4 version 1.5 is going to be release next week, so we might expect to get 'Download button' issue fixed in that version. – Murtuza Z May 12 '17 at 16:42
Thanks for your answer. – Omaruchan May 12 '17 at 16:43

score 1 · Answer 2 · edited Sep 01 '20 at 13:01

1

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

edited Sep 01 '20 at 13:01

David Buck

3,752
35
31
35

answered Sep 01 '20 at 11:44

Keshav Gopal

11
1

pgAdmin4 import/export option greyed out

2 Answers2