Re: kind of a bag of attributes in a DB . . .

Поиск

Список

Период

Сортировка

От	Chris Travers
Тема	Re: kind of a bag of attributes in a DB . . .
Дата	16 сентября 2019 г. 06:01:46
Msg-id	CAKt_ZfvG6ZL5fbZKNy4CD4BhhEjtaMjpMg2ho+LsahVqRSuRTw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: kind of a bag of attributes in a DB . . . (Albretch Mueller <lbrtchx@gmail.com>)
Список	pgsql-general

On Sat, Sep 14, 2019 at 5:11 PM Albretch Mueller <lbrtchx@gmail.com> wrote:

just download a bunch of json info files from youtube data Feeds

Actually, does postgresql has a json Driver of import feature?

Sort of.... There are a bunch of features around JSON and JSONB data types which could be useful.

the metadata contained in json files would require more than one
small databases, but such an import feature should be trivial

It is not at all trivial for a bunch of reasons inherent to the JSON specification. How to handle duplicate keys, for example.

However writing an import for JSON objects into a particular database is indeed trivial.

C

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

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

От: stan
Дата: 16 сентября 2019 г., 04:04:39
Сообщение: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

От: Tom Lane
Дата: 16 сентября 2019 г., 07:12:34
Сообщение: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?