PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostGIS was implemented as a PostgreSQL external extension.
GeoServer provides facility to combine and publish multiple layers into a single layer. You may follow the video given below to understand the process. For example in case of Landbase layers we may want to combine layers (like buildings, roads, railway, waterbodies, green area etc.) into single layers.
Earlier we were required to remember SLD nomenclature for styling layers. Then we got CSS plugin to perform layer styling. Though CSS method is still easy to adopt, but now we have even easier option. Styling layer through user-friendly GUI using GeoStyler plugin.