PostgreSQL equivalent to "SET SESSION query_cache_type = ON/OFF";
- by jack
I just wanted to know what's the equivalent query in PostgreSQL to MySQL's
SET SESSION query_cache_type = ON
SET SESSION query_cache_type = OFF
In PostgreSQL, there is a BLOB datatype called bytea. It's just an array of bytes.
bytea literals are output in the following way:
'\\037\\213\\010\\010\\005`Us\\000\\0001.fp3\'\\223\\222%'
See PostgreSQL docs for full definition of the format.
I'm trying to construct a Perl regular expression which will match any such string.
It should also…
