inserting a text file via json

Did you mean something like...?:

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 |

2014-09-05 20:51 GMT-03:00 john.tiger <john.tigernassau@gmail.com>:

we want to store markdown text files into our json fields - can this be
done ? I guess we could have a separate json field and bytea field for the
markdown file but this might be difficult when it comes to our REST
response - anyone do something like this ?

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

--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services