6 lines
199 B
SQL
6 lines
199 B
SQL
UPDATE site_settings
|
|
SET social_links = (social_links #>> '{}')::jsonb
|
|
WHERE jsonb_typeof(social_links) = 'string'
|
|
AND (social_links #>> '{}') IS NOT NULL
|
|
AND (social_links #>> '{}') ~ '^\s*\[';
|