Heidisql: PostgreSQL JSONB type not recognized

[yz778]

Steps to reproduce this issue

1. Create Table, add Column. JSONB is not in the dropdown.
2. Create table by SQL:

CREATE TABLE test (
    val1 JSON,
    val2 JSONB
)

1. Verify table created successfully:

    column_name,
    data_type
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name = 'test';

Shows

column_name   data_type
val1          json
val2          jsonb

1. Refresh DB browser, Edit table - Datatype for val2 column listed as UNKNOWN. Also in logs we see: /* Unknown datatype "JSONB" for "val2". Fall back to UNKNOWN. */

Current behavior

JSONB data type not recognized.

Expected behavior

JSONB data type should be recognized, it's functionally equivalent to JSON.

Possible solution

Add JSONB as valid datatype for PostgreSQL.

Environment

• HeidiSQL version:
  10.1.0.5464
• Database system and version:
  psql (PostgreSQL) 10.7 (Ubuntu 10.7-0ubuntu0.18.04.1)

[albertotn]

Just found this blocking problem, when creatign a table with jsonb type, column is UNKNOWN:

configuration order is jsonb type

[noxonsu]

same problem

[bpasha7]

same problem

[ansgarbecker]

Next build now supports JSONB columns:

However, not sure if editing such columns in the data grid or query grid fails, as it's binary data.