Skip to content
Aiven Logo
    • Apache Kafka®

    • PostgreSQL®

    • OpenSearch®

    • ClickHouse®

    • Valkey™

    • MySQL

    • Metrics

    • Grafana®

    • Apps

    • DataHub


    • Aiven Platform

    • Free tier

    • Developer tier

    • Partners

    • Startup

    • Enterprise Program

    • OEM

    • Case studies

  • For developers

    • Documentation

    • API reference

    • MCP

    • Aiven Agents

    • Open source

    • Changelog

    • Aiven status

    Free tools

    • SQL Syntax Checker

    • SQL Optimizer

    • PostgreSQL Playground

    • SQL Formatter

    • Kafka Visualization

    • View all free tools

  • Pricing
  • Blog
Book a demo
Get building
Developer Center
  • Apps
  • Databases
  • Streaming
  • AlloyDB Omni
  • Apache Flink®
  • Apache Kafka®
  • ClickHouse®
  • MySQL
  • OpenSearch®
  • PostgreSQL®
  • Redis®
  • Valkey
  • Apps
  • Databases
  • Streaming
  • AlloyDB Omni
  • Apache Flink®
  • Apache Kafka®
  • ClickHouse®
  • MySQL
  • OpenSearch®
  • PostgreSQL®
  • Redis®
  • Valkey
  1. Aiven Developer Center
  2. Cheat sheet

Cheat sheet

  • PostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup Guide

    A cheatsheet for the PostgreSQL® JSONB functions, providing a set of consistent examples of all the most common JSONB (and JSON) functions and operators.

      PostgreSQL®
      Cheat sheet
Aiven Logo
  • GitHub
  • Facebook
  • LinkedIn
  • X
  • YouTube

Company

  • About
  • Open source
  • Partners
  • Careers
  • Sustainability
  • Modern slavery statement
  • Press
  • Blog

Legal

  • Terms
  • SLA
  • AUP
  • Data processing
  • Privacy
  • DSA contact
  • Cookie policy
  • Website terms of use
  • Privacy Notice for California Residents

Platform

  • Responsibility matrix
  • Subprocessors
  • Security and compliance
  • Resource library
  • Support services
  • Changelog
  • Aiven status

Contact

  • Contact us
  • Book a demo
  • Support
  • Invoice address
  • Events calendar
Loading...

Copyright © Aiven 2016-2026. Apache, Apache Kafka, Kafka, Apache Flink, and Flink are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries. ClickHouse is a registered trademark of ClickHouse, Inc. OpenSearch, PostgreSQL, MySQL, Grafana, Dragonfly, Valkey, Thanos, Terraform, and Kubernetes are trademarks and property of their respective owners. All product and service names used in this website are for identification purposes only and do not imply endorsement.