Postgres Pro
Downloads
Home   >   mailing lists

Re: ordinal not in range when downloading result set as CSV - Mailing list pgadmin-support

From Murtuza Zabuawala
Subject Re: ordinal not in range when downloading result set as CSV
Date
Msg-id CAKKotZQT-Enmzicf=PdKzvbVa5WOxnbeyqG-Yu3Wdp6VkonwEw@mail.gmail.com
Whole thread Raw
In response to ordinal not in range when downloading result set as CSV  (Erik Myllymaki <erik.myllymaki@gmail.com>)
List pgadmin-support
Tree view
This issue occurs when you have some encoded data which pgAdmin4 can't decode while generating CSV file.

You can report this issue here, Please also include details to produce the issue​ (if possible also include some sample data), PG version (encoding details), Platform (encoding details) etc.

On Fri, Nov 3, 2017 at 2:04 AM, Erik Myllymaki <erik.myllymaki@gmail.com> wrote:

I"m trying to download the result set of a SQL query to csv and I get this error:

'ascii' codec can't encode character u'\ufeff' in position 33: ordinal not in range(128)

Any pointers appreciated, thanks.

This on Ubuntu 16.04:

Version
2.0
Copyright
Copyright 2013 - 2017, The pgAdmin Development Team
Python Version
2.7.12 (default, Nov 19 2016, 06:48:10) [GCC 5.4.0 20160609]
Flask Version
0.11.1
Application Mode
Desktop

pgadmin-support by date:

Previous
From: Richard Greenwood
Date:
Subject: Re: F5 - irritating behaviour
Next
From: Durumdara
Date:
Subject: PGAdmin request: Drop object and Disconnect is too close to eachother in local menu