Re: inserting json content from a file into table column

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Shashank Dutt Jha <shashank(dot)dj(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: inserting json content from a file into table column
Date: 2016-02-10 15:22:41
Message-ID: 56BB55C1.4060305@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shashank Dutt Jha 2016-02-10 16:01:39 Re: inserting json content from a file into table column
Previous Message Shashank Dutt Jha 2016-02-10 15:10:03 inserting json content from a file into table column