QGIS – Load data into PostGIS

By David Crowther

Question:

How can I load data into my PostGIS database?

Answer:

Why not use the Export to PostgreSQL tool available in the Processing Toolbox!

From the Processing menu choose > Toolbox > open the Database section and choose the Export to PostgreSQL menu option.

The Export to PostgreSQL Tool will open.

We will use the following settings:

• Input Layer - choose the GIS file that you wish to upload – in this example UK Ceremonial Counties
• Database – choose your PostGIS database Connection – this will need to have been created already
• Schema – choose the Schema within your PostGIS database that you wish to upload the layer into. Here we will choose Public
• Table – choose a name for the uploaded layer e.g., uk_counties or leave it blank to use the existing layer name
• Primary Key Field – choose an existing field in your data to assign as the Primary Key
• Geometry Column – choose a field name for the geometry column, the default will be geom

There are also some additional options that you can choose to tick and apply where needed:

If you now Run the Export to PostgreSQL Tool, the chosen GIS layer will then be uploaded and imported into the PostGIS database.

Now, within QGIS you can use the Add Layers > PostGIS option to connect to PostGIS and add your new PostGIS table –