Re: raw output from copy

\copy (select '{"foo": "bar"}') to '/tmp/raw_test.jsonb' (format raw);

COPY 1

create temporary table raw_byte (b bytea);

CREATE TABLE

create temporary table raw_text (t text);

CREATE TABLE

\copy raw_jsonb from '/tmp/raw_test.blob' (format raw);

psql:/home/ubuntu/raw_test.sql:9: ERROR:  relation "raw_jsonb" does not exist

\copy raw_byte from '/tmp/raw_test.blob' (format raw);

COPY 1

select encode(b,'escape')::text::json from raw_byte;

     encode     

----------------

 {"foo": "bar"}

(1 row)

\copy raw_text from '/tmp/raw_test.blob' (format raw);

COPY 1

select t::jsonb from raw_text;

       t        

----------------

 {"foo": "bar"}

(1 row)

create temporary table binary_byte (b bytea);

CREATE TABLE

create temporary table binary_text (t text);

CREATE TABLE

\copy binary_byte from '/tmp/raw_test.blob' (format binary);

psql:/home/ubuntu/raw_test.sql:22: ERROR:  COPY file signature not recognized

select encode(b,'escape')::jsonb from binary_byte;

 encode 

--------

(0 rows)

\copy binary_text from '/tmp/raw_test.blob' (format binary);

psql:/home/ubuntu/raw_test.sql:26: ERROR:  COPY file signature not recognized

select t::jsonb from binary_text;

 t 

---

(0 rows)