search

zaratanDotWorld / choreWheel

Computational governance tooling
GNU Affero General Public License v3.0
9 stars 0 forks source link

Migrate json columns to jsonb #116

Closed kronosapiens closed 8 months ago

kronosapiens commented 8 months ago

It turns out that jsonb types are better than json for our use-case. We should migrate the columns before opening the beta.

https://technotrampoline.com/articles/converting-json-to-jsonb-in-postgresql/

ALTER TABLE table
   ALTER COLUMN "metadata"
   SET DATA TYPE jsonb;

ALTER TABLE table
   ALTER COLUMN "metadata"
   SET DATA TYPE jsonb;
kronosapiens commented 8 months ago

Closed with a6d4fe9ea96698823c5ff6857dc92e689334f294