SQuirreL SQL client does not show Json data

Question

I just have a Postgres database(PostgreSQL 9.4.5) and Squirrel windows client (SQuirreL SQL Client Version 3.7).

In database there is a table which has column type jsonb

 Column | Type --------+-------  id     | uuid  jddd   | jsonb 

when I do

select jddd from request; 

I see

<other> 

in the results area. When I do the same in psql command line client I see JSON data which are there. I tired to google it but I found no posts related to this topic at all.

This was promising https://sourceforge.net/p/squirrel-sql/bugs/1139/ but did not help neither:-(

Thanks in advance,

st.

Answer 1

Under the following two sections:

1. Global Preferences > Data Type Controls > SQL Other (SQL type 1111)
2. Global Preferences > Data Type Controls > Unknown DataTypes (non-standard SQL type codes)

you should check the checkboxes saying

[X] Read contents when table is first loaded and display as string

as shown in the below image: