Top "Postgresql-json" questions

How do I modify fields inside the new PostgreSQL JSON datatype?

With postgresql 9.3 I can SELECT specific fields of a JSON data type, but how do you modify them using UPDATE? …

json postgresql postgresql-9.3 postgresql-json

Explanation of JSONB introduced by PostgreSQL

PostgreSQL just introduced JSONB and it's already trending on hacker news. It would be great if someone could explain how …

json postgresql nosql postgresql-json jsonb

PostgreSQL: Remove attribute from JSON column

I need to remove some attributes from a json type column. The Table: CREATE TABLE my_table( id VARCHAR(80), data …

sql json postgresql postgresql-json

Distinct on Postgresql JSON data column

Trying to do distinct on a mode with rails. 2.1.1 :450 > u.profiles.select("profiles.*").distinct Profile Load (0.9ms) SELECT DISTINCT …

ruby-on-rails ruby-on-rails-3 postgresql postgresql-json

JSON Schema validation in PostgreSQL?

I can't find any information about JSON schema validation in PostgreSQL, is there any way to implement JSON Schema validation …

json postgresql jsonschema postgresql-json

Using JSONB_ARRAY_ELEMENTS with WHERE ... IN condition

Online poker players can optionally purchase access to playroom 1 or playroom 2. And they can be temporarily banned for cheating. CREATE …

postgresql select where-in postgresql-9.5 postgresql-json

Postgres recursive query with row_to_json

I've got a table in postgres 9.3.5 that looks like this: CREATE TABLE customer_area_node ( id bigserial NOT NULL, customer_…

sql json postgresql recursion postgresql-json