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).

There is a table with jsonb column type in the database

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 the psql command-line client, I see the JSON data that is there. I am tired of Google, but I did not find any posts related to this topic at all.

This was promisingly https://sourceforge.net/p/squirrel-sql/bugs/1139/ , but it didn't help either: - (

Thank you in advance,

st.

Answer 1

In the following two sections:

1. Global Settings> Data Type Controls> SQL Other (SQL Type 1111)
2. Global Settings> Data Type Controls> Unknown Data Types (Custom SQL Type Codes)

You must check the box opposite.

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

as shown in the picture below: