Re: inserting json content from a file into table column - Mailing list pgsql-sql

From Shashank Dutt Jha
Subject Re: inserting json content from a file into table column
Date
Msg-id CAKkUp98kBsogfZSjN140R98KO_2ew90KbzfqjRCBx_Ozhg_KuQ@mail.gmail.com
Whole thread Raw
In response to Re: inserting json content from a file into table column  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: inserting json content from a file into table column  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
<div dir="ltr">psql. PostgreSQL v9.5</div><div class="gmail_extra"><br /><div class="gmail_quote">On Wed, Feb 10, 2016
at8:52 PM, Adrian Klaver <span dir="ltr"><<a href="mailto:adrian.klaver@aklaver.com"
target="_blank">adrian.klaver@aklaver.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On 02/10/2016 07:10 AM, Shashank
DuttJha wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">I have .json file.C:/ a.json<br /> Table with column 'food' of type jsonb<br /><br /> how to
insertthe content of a.json into column 'food'<br /></blockquote><br /></div></div> What are you using as your client,
forexample psql, Java program, Python program, etc.?<br /><br /> What version of Postgres are you using? In this case
itprobably does not matter that much, but json/jsonb has changed a good deal over recent versions so it is nice to know
whatyou are working with.<span class="HOEnZb"><font color="#888888"><br /><br /><br /> -- <br /> Adrian Klaver<br /><a
href="mailto:adrian.klaver@aklaver.com"target="_blank">adrian.klaver@aklaver.com</a><br
/></font></span></blockquote></div><br/></div> 

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: inserting json content from a file into table column
Next
From: Adrian Klaver
Date:
Subject: Re: inserting json content from a file into table column