inserting json content from a file into table column

From: Shashank Dutt Jha <shashank(dot)dj(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: inserting json content from a file into table column
Date: 2016-02-10 15:10:03
Message-ID: CAKkUp9-iKD+e-=z0pQDB=K874aa6cRJdNdPPZws_SjO_ZSMQ_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2016-02-10 15:22:41 Re: inserting json content from a file into table column
Previous Message Thomas Kellerer 2016-02-10 06:52:38 Re: Need documentation for PostgreSQL Replication support.