Menu
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.
667
Click the name of the view that you want to display. A tab with the view name appears in the object pane, with the Columns subtab displayed. You can view the view definition on this tab.
SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool.
After you open your session, click the Objects tab, then expand the tree. Expand the db, schema, and then table nodes, and you'll see all of your tables. If you click on a particular table node, a table will open to the right. By clicking the Columns tab, you can get the column names, types, and other meta data.
Under the following two sections:
you should check the checkboxes saying
[X] Read contents when table is first loaded and display as string
as shown in the below image:
119
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
