Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

pgAdmin4 import/export option greyed out

Tags:

postgresql

pgadmin-4

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

like image 967
Omaruchan Avatar asked May 12 '17 16:05

Omaruchan

People also ask

How do I enable import Export in pgAdmin 4?

Using pgAdmin 4 GUI¶ tool, navigate through Tools on the menu bar to click on the Import/Export Servers option. Use the Import/Export field to select the Server Groups/Servers to be imported or exported.

How do I import files into PgAdmin4?

To import CSV using this PgAdmin Import CSV method, you have to do the following: Click on the Tools tab at the top of your PgAdmin Home Page. Select the Query Tool in the drop-down menu that appears. Enter the title and columns in your CSV file as an SQL Query.

1 Answers

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.

like image 139
Murtuza Z Avatar answered Sep 19 '22 21:09

Murtuza Z
Sign in to Comment

Related questions

QueryDSL - order by count as alias
Postgresql Catching Transaction Error and Rollback
PSQLException: Large Objects may not be used in auto-commit mode
Postgres Many-to-Many JSON Aggregation
State machine represented on DB, enforcement of state transition
broadcast not supported by sql broker transport
Cannot \copy into postgresql table which has default clock_timestamp
Converting json to nested postgres composite type
Can I update a cte?
Docker-compose MemoryError
Why is table-swapping in Postgres so verbose?
convert array_agg output to array and not string
How to return insert query result values using pg-promise helpers
Make a column NOT NULL in a large table without locking issues?
Postgres aggregate alias for group_concat using string_agg
Custom Postgresql Sequence Nextval in SequelizeJS
How to tell from Npgsql exception if the call is worth a retry (transient fault strategy)
psql expanded display - avoid dashes
How to insert data into table using stored procedures in postgresql
Postgresql - update rule - possible to have a last modified date, automatically updated "on update" of that row?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!