Skip to content

Instantly share code, notes, and snippets.

@jngbng
jngbng / jsonb_remove_keys.sql
Created February 20, 2019 03:46 — forked from yyscamper/jsonb_remove_keys.sql
PostgreSQL: Remove Multiple Keys From JSONB
CREATE OR REPLACE FUNCTION jsonb_remove_keys(
jdata JSONB,
keys TEXT[]
)
RETURNS JSONB AS $$
DECLARE
result JSONB;
len INT;
target TEXT;