Re: inserting a text file via json

postgres=# \! echo "{\"menu\": { \"id\": \"file\" }}" > /opt/pgdata/exampl.json
postgres=# select pg_read_file('/opt/pgdata/exampl.json');
        pg_read_file       
----------------------------
 {"menu": { "id": "file" }}+
 
(1 row)

postgres=# select pg_read_file('/opt/bdr/bdr1/exampl.json')::json;
        pg_read_file       
----------------------------
 {"menu": { "id": "file" }}+
 
(1 row)

postgres=# create table json_exam as select pg_read_file('/opt/bdr/bdr1/exampl.json')::json as jsonColumn;
SELECT 1
postgres=# \d json_exam 
   Table "public.json_exam"
   Column   | Type | Modifiers
------------+------+-----------
 jsoncolumn | json |