Re: JSONB filed with default JSON from a file

From: mrcasa bengaluru <mrcasablr(at)gmail(dot)com>
To: Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: JSONB filed with default JSON from a file
Date: 2018-08-13 17:55:48
Message-ID: CALpZ+OStrE8EC51KgChTd4HTvd50LSXatHzCqLuUdK0_pdfANQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I assume that you could declare the column as
>
> address jsonb not null default 'your json here'::jsonb;
>

Thanks! However, this involves writing the entire JSON in the schema file
looks inconvenient. I was hoping I would be able to reference to an
external JSON file which could be used for the default value.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2018-08-13 18:00:56 Re: JSONB filed with default JSON from a file
Previous Message Charles Clavadetscher 2018-08-13 17:51:52 Re: JSONB filed with default JSON from a file