Let's assume we have a table where it has two columns, one an ID and one an hstore column, which stores key/value pairs.
You could query that column as such:
SELECT name, attributes->'device' as device FROM products WHERE attributes->'edition'= 'ebook'
Can you create a view for this table where the keys/values appear as columns in the view instead of all in the
Example: I have an hstore key where it might have the key of amenity. I want to create a view showing the the ID and the amenity values in a new view.