PostgreSQL: Get a full length column string in PgAdmin

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

I know most of the Postgres developers faced an issue like whenever they are selecting table column result that time they may get broken string (…) in PgAdmin.

In this post, I am sharing a solution to select a full-length string of your tables in PostgreSQL.
You are getting the broken string as a result because of the default setting. Characters per column set to 250, so you can select max 250 characters.

If you want to select a full string of your column, go to PgAdmin object explorer -> go to file menu -> go to Options… -> select Query Editor -> change the value of Max. characters per column.

Example, execute below select before any changes:

The Result #1:

The Result #2: After change the limit of Max. characters per column 250 to 2000, you can get a full length string.