postgresql pgAdmin III 为什么查询结果被缩短?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/19657852/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-21 01:10:15  来源:igfitidea点击:

pgAdmin III Why query results are shortened?

postgresqlpgadmin

提问by Max Gruzin

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

我最近安装了 pgAdmin III 1.18.1 并注意到一个奇怪的事情:

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

长 json 查询结果被缩短为 256 个符号,然后添加 '(...)'。

Could someone help me disable this shortening?

有人可以帮我禁用这种缩短吗?

回答by Max Gruzin

Thanks to user Erwin Brandstetterfor his answer on Database Administrators.

感谢用户Erwin Brandstetter数据库管理员的回答。

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.

选项中有一个设置:每列最大字符数 - 在处理大列时很有用。显然您的设置是 256 个字符。

pgadmin maxcharacter 属性

将其设置得更高或将其设置为 -1 以禁用该功能。