Community

Public Snippets 1

Code shared by the SaveSnippets community — browse, copy, and get inspired.

#jsonb Clear
Tags #php #kotlin #bash #go #sql #rust #typescript #html #java #python #files #utils #strings #http #concurrency #async #json #arrays #security #types #crypto #database #dates #format
SQL JSONB Columns (PostgreSQL)
`jsonb` stores binary-optimized JSON. Index sub-fields with GIN for fast containment queries. Most-used operators: `->` (get field), `->>` (get as text), `@>` (contains), `?` (key exists).
#sql #postgresql #json #jsonb #gin
admin @admin ADMIN 1d ago 0
View