Re: Bug in pgadmin III displaying/exporting data

Godshall Michael wrote:

> Hi,
>
> I am running version 1.0.0, Win2k, english version, and postgresql
> 7.3.4 under cygwin.
>
> In the File->Options->Query->max. characters per column I have changed
> the default to 5000 characters. When I run a query in a pgadminIII
> the columns that I have defined as text stop displaying data after 511
> characters.
>
> If I choose to export the data from the query screen the data in for
> my text columns is also truncated at 511 characters.

> If I use postgresql copy command in pgadminIII window to export the
> data to a file then the data is not truncated.

Bad news... If max chars per column is defined, a truncation performed
by pgAdmin3 is visualized by appended " (..)". It seems that the
listview isn't able to display more than 511 chars, this might be win32
specific (use linux... :-), or a restriction of wx (we'd fix this)

I'll check this; if win32 is guilty (I believe so) we're stuck. It must
be quite hard to display this anyway, lot of scrolling necessary...
In this case, I'd suggest to export the data and use an editor,
obviously you already did so.

Regards,
Andreas

>
> I have tried closing out pgadminIII and re-opening but the data is
> still truncated.
>
> Michael Godshall
> GMAC Global Relocation Services <http://www.gmacglobalrelocation.com/>
>
> michael_godshall(at)gmachs(dot)com <mailto:michael_godshall(at)gmachs(dot)com>
>
>