Re: JSONB filed with default JSON from a file

[mrcasa bengaluru <mrcasablr@xxxxxxxxx>]

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.