How to add JSONB columns for PostgreSQL?

Osman · October 15, 2015, 3:14am

Hello,

I am having trouble finding the syntax to create PostgreSQL JSONB columns in a new table. Is this supported? If not, how can I get this to work? Just run a raw SQL query?

Thanks

un1410866548036r81id · October 15, 2015, 3:14am

Just use jsonb as the type:

Topic		Replies	Views
JSON column type for PostgreSQL, Oracle, MSSqlServer and H2 General Discussion	1	3857	October 5, 2022
loadData + Column Type JSONB is having problem General Discussion	2	4097	January 12, 2021
PostgreSQL Subtable via 'inherits' General Discussion	2	626	December 4, 2009
Trouble with generating new column Liquibase Development	2	609	May 18, 2021
Define Not Null column on <createTable> tag General Discussion	1	573	September 27, 2013

How to add JSONB columns for PostgreSQL?

Related topics