title: QGIS Add geometry to attribute table
body: <p>I am importing my data into QGIS from a local postgreSQL server. The dataset loaded into the database contains 11 columns including a X and Y column which are in the CRS (Coodinate Reference System): EPSG:21781, CH1903 / LV03. I am trying to plot these points as a layer in QGIS but when I import it using the “Add PostGIS layer” I have to click “Also list tables with no geometry” to find it. Once added it appears as an attribute table which I can go into the layer properties and select the correct CRS but it still doesn't appear correctly. </p>
  
  <p><a href="https://i.stack.imgur.com/dw0y9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dw0y9.png" alt="QGIS layer properties"></a></p>
  
  <p>I am still new to QGIS and PostgreSQL, am I doing something wrong or do I need to define the coordinates in the database before I import them to QGIS?</p>