Postgres Pro
Downloads
Home   >   mailing lists

Re: kind of a bag of attributes in a DB . . . - Mailing list pgsql-general

From Chris Travers
Subject Re: kind of a bag of attributes in a DB . . .
Date
Msg-id CAKt_ZfvG6ZL5fbZKNy4CD4BhhEjtaMjpMg2ho+LsahVqRSuRTw@mail.gmail.com
Whole thread Raw
In response to Re: kind of a bag of attributes in a DB . . .  (Albretch Mueller <lbrtchx@gmail.com>)
List pgsql-general
Tree view


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 by date:

Previous
From: stan
Date:
Subject: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?
Next
From: Tom Lane
Date:
Subject: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?