Re: inserting json content from a file into table column

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Shashank Dutt Jha <shashank.dj@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: inserting json content from a file into table column
Date: Wed, 10 Feb 2016 07:22:41 -0800
Message-ID: <56BB55C1.4060305@aklaver.com> (raw)
In-Reply-To: <CAKkUp9-iKD+e-=z0pQDB=K874aa6cRJdNdPPZws_SjO_ZSMQ_w@mail.gmail.com>
References: <CAKkUp9-iKD+e-=z0pQDB=K874aa6cRJdNdPPZws_SjO_ZSMQ_w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.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

view thread (6+ messages)  latest in thread

Message-ID: <56BB55C1.4060305@aklaver.com>
Permalink:  ../56BB55C1.4060305@aklaver.com/
Also on:    postgresql.org/message-id/56BB55C1.4060305@aklaver.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: adrian.klaver@aklaver.com, shashank.dj@gmail.com
  Subject: Re: inserting json content from a file into table column
  In-Reply-To: <56BB55C1.4060305@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox