Re: 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(dot)tigernassau(at)gmail(dot)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(at)postgresql(dot)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