Skip to content

Instantly share code, notes, and snippets.

@omidp

omidp/gist:7563ef6fecbcf947949f4d656fac97ec

Created April 15, 2021 15:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save omidp/7563ef6fecbcf947949f4d656fac97ec to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save omidp/7563ef6fecbcf947949f4d656fac97ec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT *
FROM OPENDATA
WHERE other_tags IS NOT JSON;
create search index table_log_idx on tbl_lg (jsoncolumn) for json;
alter table table_log_idx add constraint ensure_json check (jsoncolumn is json)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment