You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Create Table, add Column. JSONB is not in the dropdown.
Create table by SQL:
CREATE TABLE test (
val1 JSON,
val2 JSONB
)
Verify table created successfully:
SELECT
column_name,
data_type
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'test';
Shows
column_name data_type
val1 json
val2 jsonb
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)
The text was updated successfully, but these errors were encountered:
Steps to reproduce this issue
Shows
/* 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
10.1.0.5464
psql (PostgreSQL) 10.7 (Ubuntu 10.7-0ubuntu0.18.04.1)
The text was updated successfully, but these errors were encountered: