Request a Demo
Home   >   mailing lists

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
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
List pgsql-sql
Tree view
psql. PostgreSQL v9.5

On Wed, Feb 10, 2016 at 8:52 PM, Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com

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