Re: JSONB filed with default JSON from a file

Поиск
Список
Период
Сортировка
От mrcasa bengaluru
Тема Re: JSONB filed with default JSON from a file
Дата
Msg-id CALpZ+OStrE8EC51KgChTd4HTvd50LSXatHzCqLuUdK0_pdfANQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JSONB filed with default JSON from a file  (Charles Clavadetscher <clavadetscher@swisspug.org>)
Ответы Re: JSONB filed with default JSON from a file  (Merlin Moncure <mmoncure@gmail.com>)
Список 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. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Charles Clavadetscher
Дата:
Сообщение: Re: JSONB filed with default JSON from a file
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: JSONB filed with default JSON from a file