Thread: Select data in in pgadmin 1.18

Select data in in pgadmin 1.18

From
fankotor
Date:
Hello,

I have the following issue:
When i select large columns in pgadmin 1.18, when i copy/paste data to a
text editor, i get only a part of the data, followed by (...)
pgadmin 1.14 doesn't have this problem.

How can i select the entire column?

Thanks



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Select-data-in-in-pgadmin-1-18-tp5789842.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.



Re: Select data in in pgadmin 1.18

From
fankotor
Date:
I'll try to rephrase what I said above, I think my first message was a bit
unclear.
Let's say I have table X.
Table X has 2 columns: id and description.
Let's say id = 1 has a very large description (more than 1000 characters).
When I:

select description from X where id = 1

I can't view the entire column in pgadmin (the 'description'  column doesn't
resize so that I can't see the whole text). So, I copy/paste the column in
Notepad++. When I do this, surprise :) I can only see the first 256
characters, folowed by (...) 
Something like:

abcdefghij (...)

But with 256 characters instead of 10.
Maybe I'm wrong, but I think select is supposed to be the ultimate method
for selecting data.
Is this a bug or (hopefully) I can disable this behaviour somehow?
Like I said, the same select works great with pgadmin 1.14.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Select-data-in-in-pgadmin-1-18-tp5789842p5790309.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.