How to check if JSON contains in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides several different ways to check if a value/field from a JSON document:
What are the differences between JSON or JSONB in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data:
JSONstores the JSON as text, performing a validation on the correctness of the JSON syntaxJSONBoptimizes the JSON storage in a custom binary format. Therefore, on top of validating the correctness of the JSON format, time is spent to properly parse and store the content.
PostgreSQL Community and you
I started following the #PGSQLPhriday initiative a couple months back but never had the time to properly sit down and write due to conference traveling. Therefore I was super happy to be at home this week and find out that PGSQL Phriday #003 theme is about the PostgreSQL community!
Define a PostgreSQL database connection in JSON and import it in PGAdmin 4
How to define a database connection in a JSON file that can be imported in PG Admin 4
