JSON column type for PostgreSQL, Oracle, MSSqlServer and H2

General Discussion
1

Hi all,

I’m a Liquibase beginner and I’m not finding the way to specify a JSON type in Liquibase documentation (https://www.liquibase.org/documentation/column.html)

For PostgreSQL I found this simple answer https://forum.liquibase.org/topic/how-to-add-jsonb-columns-for-postgresql so I’m supposing to create one separate column definition for each dbms I have to manage, is this the right way to use Liquibase to manage such a situation?

Currently I’m writing only create table changeset.

Thanks and best regards

Raffaele

2

Hi there @rgambelli

I’m doing a little forum housekeeping and came across this old post from 2020. I’m betting you resolved this a long time ago, but just in case…

IMO, the best way to understand how Liquibase handles situations like that is by taking the free Liquibase University courses we offer. You can sign up at https://university.liquibase.com

Kindly,
Tabby