Trying to alter a jsonb column's default type to be empty jsonb.
I'm attempting to run this:
alter table public.profiles ALTER COLUMN socials jsonb not null default '{}'::jsonb
Getting this error:
Failed to validate sql query: syntax error at or near "jsonb"
alter table public.profiles ALTER COLUMN socials jsonb not null default '{}'::jsonb
Getting this error:
Failed to validate sql query: syntax error at or near "jsonb"
