First of all, let's load the two layers saved on the disk--the GeoNames and the administrative boundaries layers. We can import layers with the Import layer/file button accessed from QGIS's database manager. QGIS automatically converts the specified layer to a PostGIS table by providing the required properties. We can import virtually any vector layer with the following steps:
- Choose the input layer in the Input field. We can also specify layers not loaded in QGIS with the browse button (...) next to the field.
- Choose a Schema to load the layer into. In our case, the public schema is the only one available.
- Provide a table (PostGIS layer) name in the Table field.
- Define the source and target projections. It can be omitted ...
