本文是小编为大家收集整理的关于如何在pg管理工具中增加显示长度的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。
问题描述
我有一个愚蠢的问题.基本上，我刚刚从PGSQL 8.4升级到9.1，并升级到PGADMIN 1.20.
我有一些表具有较大文本字段的表，并且在上一个查询工具中，我可以查询一行并将数据复制以修改数据.在这种情况下，我有一个表格存储可以运行的查询的表.
我升级到新的PGADMIN版本后，当我使用该工具并查询一行从该行中的字段中拉出文本时，它会截断结果并以椭圆形结尾(...).
我试图弄清楚如何增加MEM上的MEM，因此它在100个字符左右后不会截断，但不能截断.
任何人都有任何想法?
推荐答案
在PGADMIN选项中，您可以更改字段的长度.请执行下列操作， 转到:
文件>选项>查询工具>最大.每个列字符
默认情况下是256，您可以相应地增加它.
希望这有帮助
其他推荐答案
Marlon Abeykoon的答案很好，但是如果您想要一次性输出并且不想更改设置，则简单地输出到文件(从通常的绿色'go'箭头沿着两个按钮).这将整个输出保存在CSV文件中.
问题描述
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.
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 (...).
I tried figuring out how to increase the mem on this so it doesn't truncate after 100 characters or so but couldn't.
Anybody have any ideas??
推荐答案
In pgAdmin options, you can change the length of the field. Do the following, Go to:
File > Options > Query Tool > Max. characters per column
By default it is 256, you can increase it accordingly.
Hope this helps
其他推荐答案
Marlon Abeykoon's answer is good, but if you want a one-off output and don't want to change settings, then simply output to a file (two buttons along from the usual green 'go' arrow). This saves the entire output in a csv file.
更多相关问答
联系站长