Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pgAdmin III Why query results are shortened?

I've recently installed pgAdmin III 1.18.1 and noticed a strange thing:

Long json query results are shortened to 256 symbols and then ' (...)' is added.

Could someone help me disable this shortening?

like image 513
Max Gruzin Avatar asked Oct 29 '13 12:10

Max Gruzin


1 Answers

Thanks to user Erwin Brandstetter for his answer on Database Administrators.

There is a setting for that in the options: Max characters per column - useful when dealing with big columns. Obviously your setting is 256 characters.

pgadmin maxcharacter property

Set it higher or set it to -1 to disable the feature.

like image 158
Max Gruzin Avatar answered Sep 17 '22 01:09

Max Gruzin