Re: Bug in pgadmin III displaying/exporting dat

Ok,

In pgadminII I could choose to output the results directly to a text file
without having them first displayed on the screen. That is what I was
really trying to do(I normally don't try to read the 5000 characters in the
pgadmin window).

Is their a way to do this in pgadminIII without first having it try to
display the data?

I guess I can insert my select * from X into a temp table and then use the
postgresql copy command to export the temp table into a text file. It just
is a little more work than just selecting the output to text from the drop
down box.

I use linux at home and would test it there if I can get pgadminIII
installed on it. Last time I tried it failed because I did not have ssl and
crypto so.4 libraries. My Redhat 8.0 box has versions so.2. Maybe I
downloaded the wrong version of pgadminIII.

Thanks for the response.

Mike
-----Original Message-----
From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de]
Sent: Thursday, October 02, 2003 4:04 PM
To: Godshall Michael
Cc: 'pgadmin-support(at)postgresql(dot)org'
Subject: Re: [pgadmin-support] Bug in pgadmin III displaying/exporting
data from query window(tr uncating)

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>
>
>