HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Why are query results shortened in pgAdmin 1.18.1?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
pgadminwhyarequeryshortenedresults

Problem

I've recently installed pgAdmin 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?

Solution

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.

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

Consult the fine manual here for more details.

Context

StackExchange Database Administrators Q#52399, answer score: 9

Revisions (0)

No revisions yet.