Postgres Pro
Downloads
Home   >   mailing lists

Bug in pgadmin III displaying/exporting data from query window(tr uncating) - Mailing list pgadmin-support

From Godshall Michael
Subject Bug in pgadmin III displaying/exporting data from query window(tr uncating)
Date
Msg-id A596FA3368757645AF862C701495CA0001B446CA@hor1mspmx01.gmachs.com
Whole thread Raw
Responses Re: Bug in pgadmin III displaying/exporting data
List pgadmin-support
Tree view
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.
 
I have tried closing out pgadminIII and re-opening but the data is still truncated.

Michael Godshall
GMAC Global Relocation Services

michael_godshall@gmachs.com

 

pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Reverse engineered Column definition incorrect
Next
From: Andreas Pflug
Date:
Subject: Re: Bug in pgadmin III displaying/exporting data