Search code examples
postgresqlpgadmin

pgAdmin: How to see complete value in a cell in output


I have a query which gives me the large output value in the output cell. But the problem is that for reading I need to drag the column and see the value and after some range the values are not displaying instead it's showing me (...). After copying the value also I am unable to get the whole set of value.

enter image description here

enter image description here

Question: How can I see the whole set of value from the output?


Solution

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

    Details:

    More in the manual here.