Django ORM PostgreSQL

Django ORM PostgreSQL

Explore django orm postgresql code snippets and tutorials

Django ORM PostgreSQL

JSON builders, DISTINCT ON, collation & generated columns

Odds and ends unique to PostgreSQL: JSONObject/JSONArray build JSON from columns; .distinct('author') is SQL DISTINCT ON (one row per author); a non-deterministic db_collation makes nickname comparisons case-insensitive; and a GeneratedField …

Django ORM PostgreSQL

JSONField lookups (nested key, contains, has_key)

JSONField stores jsonb.

Django ORM PostgreSQL

ArrayField lookups (contains, overlap, len, index)

ArrayField maps to a real PostgreSQL array.

Django ORM PostgreSQL

Subquery / OuterRef / Exists

OuterRef('pk') refers to the outer row from inside a subquery.

Django ORM PostgreSQL

Case/When, F arithmetic, ExpressionWrapper, Coalesce

Case/When is SQL CASE.