pgadmin4 - Download Query result as CSV

pgadmin-4
StackAsk picture StackAsk · Jun 1, 2017 · Viewed 10.3k times · Source

I wrote a query using the query tool in pgadmin 4. Now I want to download the results as a csv. I´ve got two problems with that.

  1. The 'Download as CSV'-button does not work sometimes. Especially when the result contains 1000+ rows.

  2. When I finally have a csv and I want to open it, this message is all I see:

    "'ascii' codec can't encode character u'\xbb' in position 26: ordinal not in range(128)"

Since I´m fairly new to all of this, could someone enlighten me to what is wrong?

Answer

anthonydb picture anthonydb · Jun 1, 2017

On your questions:

  1. The broken CSV download was a known bug that was fixed in pgAdmin v1.5 (Bug summary at the login-required https://redmine.postgresql.org/issues/2253; the gist is that there were multiple issues with exporting JSON data and Unicode). If you're not on that version, try updating and see whether you continue to have the issue.
  2. You didn't specify where you're seeing that message regarding encoding, but the character referenced in the error is a "Right-Pointing Double Angle Quotation Mark" (») (http://www.codetable.net/hex/bb).

Related questions

pgadmin4 : postgresql application server could not be contacted.

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_…

Read More
FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any …

Read More
PgAdmin4 unable to query or view data

I have a very basic PostgreSql table. Despite the simple table schema, I cannot query it via PgAdmin4. The View Data option is unresponsive; Query Tool option becomes unresponsive after a few attempts in opening and closing the panel. When …

Read More