22

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.

Nakilon
  • 34,866
  • 14
  • 107
  • 142
Stepik
  • 341
  • 2
  • 6

1 Answers1

38

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:

Snapshot for reference

rvernica
  • 1,208
  • 11
  • 11
dopeddude
  • 4,943
  • 3
  • 33
  • 41
  • 3
    As of SQuirrel SQL 20170430_2224 Global Preferences > Data Type Controls > SQL Other (SQL type 1111) Global Preferences > Data Type Controls > Unknown DataTypes (non-standard SQL type codes) – Michael Hobbs May 20 '17 at 13:32
  • Actually it is: File > Global Preferences > Data Type Controls > SQL Other (SQL type 1111) Global Preferences > Data Type Controls > ... (At least for beginners ;)) – Tom Jun 24 '20 at 10:29