Re: JSONB filed with default JSON from a file

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(at)gmail(dot)com> 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