QGIS has this nice tool to Split a layer into multiple layers based on one attribute and create a new layer for each unique value within that attribute.
Is this also possible using PostgreSQL/PostGIS? What would the SQL code look like?
edit based on comments:
I do understand this goes against the idea of a RDBMS. Creating views is indeed a more handsome way.
I do need the multiple layers for one single reason. I am building a webmap where the legend should show the individual names of the polygons that are part of a set (the all have the same value for atttribute1, consider regions). For example:
The original layer has the features 1,2,3,4, etc with attribute1 is A, B, C or D, etc
The new layers consists only of those features that have the same value in attribute1, but I do not want these features to be dissolved into one new feature/polygon. Then I put all those separate layers in a new map and style each layer with 'categorize on attribute2' but all with the same color so each feature within a layer all have the same color and each layer has a different color. Then the legend of that map looks like this:
I can do this within QGIS by using Spilt Vector Layer, and QGIS the creates six new files for each layer. Doing this with views in a database would be more convenient.