如何在pg admin工具中增加显示长度 [英] How to increase display length in pg admin tool

问题描述

我有一个愚蠢的问题.基本上，我只是从pgsql 8.4升级到9.1，然后升级到pgAdmin 1.20.

I have a dumb problem. Basically I just upgraded from pgsql 8.4 to 9.1 and upgrade to pgAdmin 1.20.

我有一些具有大文本字段的表，在以前的查询工具中，我可以查询一行并将数据复制粘贴到其中以进行修改.在这种情况下，我有一个表来存储可以运行的查询.

I have some tables that have large text fields and in the previous query tool I could query a row and copy-paste the data out of it to modify. In this case, I had a table that stored queries that I could run.

一旦我升级到新的pgAdmin版本，当我使用该工具并查询一行以从该行中的字段中提取文本时，它将截断结果并以省略号(...)结尾.

Once I upgraded to the new pgAdmin version, when I use the tool and query a row to pull out the text from a field in that row, it truncates the result and ends with an ellipsis (...).

我试图弄清楚如何增加内存，这样它就不会在100个字符左右后截断，但不能截断.

I tried figuring out how to increase the mem on this so it doesn't truncate after 100 characters or so but couldn't.

有人有什么想法吗?

推荐答案

在pgAdmin选项中，您可以更改字段的长度.请执行下列操作， 转到:

In pgAdmin options, you can change the length of the field. Do the following, Go to:

文件>选项>查询工具>最高每列字符

File > Options > Query Tool > Max. characters per column

默认情况下为256，您可以相应地增加它.
希望这对您有帮助

By default it is 256, you can increase it accordingly.
Hope this helps

这篇关于如何在pg admin工具中增加显示长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！