Cast hstore type to bytea (and later to hex possibly)

Поиск
Список
Период
Сортировка
От Igor Stassiy
Тема Cast hstore type to bytea (and later to hex possibly)
Дата
Msg-id CAKVOjeySBt4p+VxRKuSk_d+t4+mU-PuT-aho6unM7AFHsfPC7g@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Rob Richardson
Дата:
Сообщение: Re: How can I use crosstab functons in PostgreSQL 9.3?
Следующее
От: Dario Beraldi
Дата:
Сообщение: Re: Installing plpython3u