1
UPDATE datasource set metadata = (metadata::jsonb -'statisticsCalculation') 
WHERE metadata ? 'statisticsCalculation';

statement stored in sqlfile, when applying changes with liquibase postgresql driver replaces ? with $1.

<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.5</version>

Notice: works properly with driver version 9.4.x

olibiaz
  • 2,551
  • 4
  • 29
  • 31
Ilywka
  • 11
  • 2

0 Answers0