Subject: Re: inserting json content from a file into table column
To: Shashank Dutt Jha <shashank.dj@gmail.com>, pgsql-sql@postgresql.org
References: 
 <CAKkUp9-iKD+e-=z0pQDB=K874aa6cRJdNdPPZws_SjO_ZSMQ_w@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <56BB55C1.4060305@aklaver.com>
Date: Wed, 10 Feb 2016 07:22:41 -0800
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: 
 <CAKkUp9-iKD+e-=z0pQDB=K874aa6cRJdNdPPZws_SjO_ZSMQ_w@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql