Thread: BUG #13503: json_to_hstore does not works with backslash-quote in json value

The following bug has been logged on the website:

Bug reference:      13503
Logged by:          Aleksei
Email address:      kolmyk@hotmail.com
PostgreSQL version: 9.4.1
Operating system:   Windows
Description:

select json_to_hstore('{"key":"\"quoted value\""}'::json)

-- ERROR:  Syntax error near '"' at position 7
-- CONTEXT:  SQL function "json_to_hstore" statement 1

kolmyk@hotmail.com writes:
> select json_to_hstore('{"key":"\"quoted value\""}'::json)

> -- ERROR:  Syntax error near '"' at position 7
> -- CONTEXT:  SQL function "json_to_hstore" statement 1

There is no json_to_hstore() function in the standard Postgres
distribution, so we can't help you too much with whatever's
wrong with that function.

            regards, tom lane