Return to Revisions

You can transfer the desired hstore key/value data to new columns:
1-Create the desired columns (ex. addres, city, key1, key2, keyn)
2-Run:

UPDATE table 
SET 
address=hstorecolumn->address,
city=hstorecolumn->city,
key1=hstorecolumn->key1,
key2=hstorecolumn->key2,
keyn=hstorecolumn->keyn;

Or you can simply get used to hstore, it works pretty well and I have so many good results with it that I can say IMO "hstore changed my life". lol