# Viewing the data in QGIS In QGIS, click on the ‘**open PostGIS layer**’ button on the left hand side of the window.
open PostGIS layer’ button

open PostGIS layer’ button

Add PostGIS Table window showing the new connections button highlighted

Add PostGIS Table window

In the next window, a new connection will have to be set up to the newly created database containing the OS OpenMap-Local data. Click on ‘**new**’. Another window called ‘**create PostGIS connection**’ will appear. Information will be required to be entered into this window to set up the new connection.
Create a new PostGIS connection window for a local osopenmap database

Create a new PostGIS connection window

In this example, the name ‘**osopenmap**’ for the connection has been provided along with the name of the database which holds the data. Click on the ‘**Test Connect**’ button to ensure that the correct connection is made. Once successful, click ‘**OK**’. If the save username and save password boxes have been clicked, click ‘**OK**’ in the subsequent message box. A new connection will now be available in the list of PostGIS database connections. Ensuring that the correct one is listed, click on ‘**connect**’. The schema containing the OS OpenMap-Local data can be seen.
Add PostGIS Tables window

Add PostGIS Tables window

Click on the + sign next to the schema to expand the list of tables. Select all of the tables within OS OpenMap-Local that are required to be loaded to QGIS. Once all have been selected, click ‘**Add**’.
Add PostGIS table showing available tables within the openmap schema

Add PostGIS Table(s) window

The OS OpenMap-Local data will load into QGIS. The data will need to be re-ordered and then styled appropriately using personalised style files or the style files available from GitHub published by Ordnance Survey. If using these published files, please consult the accompanying ‘Quick Start Guide’ as to their use. It should be noted that there is no requirement to add a spatial index to the data from PostGIS as those indexes were added automatically during the loading of the data into PostgreSQL.
OS OpenMap Local data loaded into QGIS in the main data window

OS OpenMap Local data loaded into QGIS

If using the published style files, the output should appear as shown above. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.os.uk/os-downloads/products/maps-and-imagery-portfolio/os-openmap-local/os-openmap-local-getting-started-guide/viewing-the-data-in-qgis.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.