Re: JSONB filed with default JSON from a file

[Charles Clavadetscher <clavadetscher@xxxxxxxxxxxx>]

Hi

-----------------------------------

Charles Clavadetscher

Neugasse 84

CH - 8005 Zürich

Tel: +41-79-345 18 88

-------------------------------------

On 13.08.2018, at 19:40, mrcasa bengaluru <mrcasablr@xxxxxxxxx> wrote:

All,

I'm new to JSONB datatype. We would like to store a nested JSON file in this field. Since the JSON is nested, we wanted to create JSON with default value from an external JSON file.

My address table looks like,

CREATE TABLE address (

id CHAR(36) UNIQUE NOT NULL,

address JSONB NOT NULL

);

For example, the default JSON will look like,

$ cat address_default.json

{

  "address": {

    "address1": "175 N Street",

    "address2": "Timabktu",

    "location": [

      {

        "city": "Utopia",

        "geolocation": [

          {

            "lat": "12.345",

            "long": "12.1234"

          }

        ],

        "state": "Nowhere"

      }

    ],

    "zip": "96001"

  }

}

How do I make the address_default.json as the default JSON value for the address column?

I assume that you could declare the column as

address jsonb not null default 'your json here'::jsonb;

I did not try it, but this is what you would do with other data types.

Regards

Charles