Postgres Pro
Downloads
Home   >   mailing lists

Re: JSONB filed with default JSON from a file - Mailing list pgsql-general

From mrcasa bengaluru
Subject Re: JSONB filed with default JSON from a file
Date
Msg-id CALpZ+OStrE8EC51KgChTd4HTvd50LSXatHzCqLuUdK0_pdfANQ@mail.gmail.com
Whole thread Raw
In response to Re: JSONB filed with default JSON from a file  (Charles Clavadetscher <clavadetscher@swisspug.org>)
Responses Re: JSONB filed with default JSON from a file
List pgsql-general
Tree view
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. 

pgsql-general by date:

Previous
From: Charles Clavadetscher
Date:
Subject: Re: JSONB filed with default JSON from a file
Next
From: Merlin Moncure
Date:
Subject: Re: JSONB filed with default JSON from a file