| From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
|---|---|
| To: | Albretch Mueller <lbrtchx(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: kind of a bag of attributes in a DB . . . |
| Date: | 2019-09-16 03:01:46 |
| Message-ID: | CAKt_ZfvG6ZL5fbZKNy4CD4BhhEjtaMjpMg2ho+LsahVqRSuRTw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Sep 14, 2019 at 5:11 PM Albretch Mueller <lbrtchx(at)gmail(dot)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.
http://www.efficito.com/learn_more
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-09-16 04:12:34 | Re: FW: Re: FW: Re: Shouldn;t this trigger be called? |
| Previous Message | stan | 2019-09-16 01:04:39 | Re: FW: Re: FW: Re: Shouldn;t this trigger be called? |