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