Re: Bug in pgadmin III displaying/exporting dat - Mailing list pgadmin-support

<p><font size="2">Ok,</font><p><font size="2">In pgadminII I could choose to output the results directly to a text file
withouthaving them first displayed on the screen.  That is what I was really trying to do(I normally don't try to read
the5000 characters in the pgadmin window). </font><p><font size="2">Is their a way to do this in pgadminIII without
firsthaving it try to display the data?</font><p><font size="2">I guess I can insert my select * from X into a temp
tableand then use the postgresql copy command to export the temp table into a text file.  It just is a little more work
thanjust selecting the output to text from the drop down box.</font><p><font size="2">I use linux at home and would
testit there if I can get pgadminIII installed on it.  Last time I tried it failed because I did not have ssl and
cryptoso.4 libraries.  My Redhat 8.0 box has versions so.2.  Maybe I downloaded the wrong version of
pgadminIII.</font><p><fontsize="2">Thanks for the response.</font><p><font size="2">Mike</font><br /><font
size="2">-----OriginalMessage-----</font><br /><font size="2">From: Andreas Pflug [<a
href="mailto:pgadmin@pse-consulting.de">mailto:pgadmin@pse-consulting.de</a>]</font><br/><font size="2">Sent: Thursday,
October02, 2003 4:04 PM</font><br /><font size="2">To: Godshall Michael</font><br /><font size="2">Cc:
'pgadmin-support@postgresql.org'</font><br/><font size="2">Subject: Re: [pgadmin-support] Bug in pgadmin III
displaying/exporting</font><br/><font size="2">data from query window(tr uncating)</font><br /><p><font
size="2">GodshallMichael wrote:</font><p><font size="2">> Hi,</font><br /><font size="2">>  </font><br /><font
size="2">>I am running version 1.0.0, Win2k, english version, and postgresql </font><br /><font size="2">> 7.3.4
undercygwin. </font><br /><font size="2">>  </font><br /><font size="2">> In the
File->Options->Query->max.characters per column I have changed </font><br /><font size="2">> the default to
5000characters.  When I run a query in a pgadminIII </font><br /><font size="2">> the columns that I have defined as
textstop displaying data after 511 </font><br /><font size="2">> characters.</font><br /><font size="2">> 
</font><br/><font size="2">> If I choose to export the data from the query screen the data in for </font><br /><font
size="2">>my text columns is also truncated at 511 characters.</font><p><font size="2">> If I use postgresql copy
commandin pgadminIII window to export the </font><br /><font size="2">> data to a file then the data is not
truncated.</font><p><fontsize="2">Bad news... If max chars per column is defined, a truncation performed </font><br
/><fontsize="2">by pgAdmin3 is visualized by appended " (..)". It seems that the </font><br /><font size="2">listview
isn'table to display more than 511 chars, this might be win32 </font><br /><font size="2">specific (use linux... :-),
ora restriction of wx (we'd fix this)</font><p><font size="2">I'll check this; if win32 is guilty (I believe so) we're
stuck.It must </font><br /><font size="2">be quite hard to display this anyway, lot of scrolling necessary...</font><br
/><fontsize="2">In this case, I'd suggest to export the data and use an editor, </font><br /><font size="2">obviously
youalready did so.</font><p><font size="2">Regards,</font><br /><font size="2">Andreas</font><br /><br /><p><font
size="2">> </font><br /><font size="2">> I have tried closing out pgadminIII and re-opening but the data is
</font><br/><font size="2">> still truncated.</font><br /><font size="2">></font><br /><font size="2">>
MichaelGodshall</font><br /><font size="2">> GMAC Global Relocation Services <<a
href="http://www.gmacglobalrelocation.com/"target="_blank">http://www.gmacglobalrelocation.com/</a>></font><br
/><fontsize="2">></font><br /><font size="2">> michael_godshall@gmachs.com <<a
href="mailto:michael_godshall@gmachs.com">mailto:michael_godshall@gmachs.com</a>></font><br/><font
size="2">></font><br/><font size="2">>  </font><br />