CODEWITHSUNDEEP
postgresql
user2284928
user2284928

Reputation: 103

PostgreSQL 9.3 sql result: long text has shortened

I'm trying to SELECT some text that so long (about 500~ char), when using pg-admin > sql to test my sql, its return result which has shortened (about 250 char + '(...)').

Anybody know how to config PostgreSQL to always show fully text result ?

Thank you.

Updated

my_table(
  my_column text;
)

INSERT INTO my_table(my_column) VALUES ('this is long(500~ char more) long text');
SELECT my_column FROM my_table

output pane display: -> this is long(250~ char more) (...)

I think this will more clearly :)

Upvotes: 2

Views: 957

Answers (1)

user_0
user_0

Reputation: 3363

In pgadmin go in the menù:
File --> options

Under "Query tool", select "Query editor".

In the box "Max Characters per column", insert... a big number :-)
Maximum is 2147483647, but it can consume a lot of memory in some case... Anyway, if it is not a production server you have not to worry.

Upvotes: 2

Related Questions