| From: | Shashank Dutt Jha <shashank(dot)dj(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: inserting json content from a file into table column |
| Date: | 2016-02-10 16:01:39 |
| Message-ID: | CAKkUp98kBsogfZSjN140R98KO_2ew90KbzfqjRCBx_Ozhg_KuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
psql. PostgreSQL v9.5
On Wed, Feb 10, 2016 at 8:52 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 02/10/2016 07:10 AM, Shashank Dutt Jha wrote:
>
>> I have .json file.C:/ a.json
>> Table with column 'food' of type jsonb
>>
>> how to insert the content of a.json into column 'food'
>>
>
> What are you using as your client, for example psql, Java program, Python
> program, etc.?
>
> What version of Postgres are you using? In this case it probably does not
> matter that much, but json/jsonb has changed a good deal over recent
> versions so it is nice to know what you are working with.
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-02-10 16:34:46 | Re: inserting json content from a file into table column |
| Previous Message | Adrian Klaver | 2016-02-10 15:22:41 | Re: inserting json content from a file into table column |