Take the 2-minute tour ×  I've been evaluating PostgreSQL's
hstore functionality (9.2) and the only thing the fine manual
isn't explicit about is how to rename keys. For instance, how
could I rename the key c to ai_count?  "c"=>"3",
"ai_voltage"=>"3", "ai_temperature"=>"28"  I'm thinking there is
no direct way to do this and that it involves duplicating the c
key to a ai_count key, then dropping the c key. How can I do
this, ideally as a one-liner which can be applied to multiple
records?  share|improve this question The "fine manual",
awesome! –  mu is too short Nov 7 '12 at 16:39 add comment  1
Answer  up vote 5 down vote accepted  I think you're right that
you have to pull the old pair out and put the new pair (with the
renamed key) back in.  You could do it with a one-liner:  (h -
from_key) || hstore(to_key, h -> from_key)  where h is the
hstore, from_key is the key you want to change and to_key is
what you want to change it to. That will return a new hstore
with the desired change but it assumes that fro