Attributes from an hstore-column as separate columns in a view?
Sure you can.

CREATE VIEW v_ebooks AS
SELECT products_id, attributes-&gt;'device' AS device
FROM   products
WHERE  attributes-&gt;'edition'= 'ebook';


SQL Fiddle demo.

But only for a static set of columns. Dynamic output of all possible attributes in an hstore column conflicts with the requirement that the return type has to be declared at creation time.

This later answer provides a completely dynamic solution (in two steps):


Dynamically convert hstore keys into columns for an unknown set of keys