Cast hstore type to bytea (and later to hex possibly) - Mailing list pgsql-general

From Igor Stassiy
Subject Cast hstore type to bytea (and later to hex possibly)
Date
Msg-id CAKVOjeySBt4p+VxRKuSk_d+t4+mU-PuT-aho6unM7AFHsfPC7g@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello,

I would like to achieve something like the following:

COPY (select 'a=>x, b=>y'::hstore::bytea) TO STDOUT;

I have implemented an hstore value iterator that works with pqxx::result::field.c_str() (which has its own binary serialisation format) and I would like to reuse it to work with records that comes from stdin (in hex format for example).

How can this be done?

Thank you,
Igor

pgsql-general by date:

Previous
From: Rob Richardson
Date:
Subject: Re: How can I use crosstab functons in PostgreSQL 9.3?
Next
From: Dario Beraldi
Date:
Subject: Re: Installing plpython3u