Creating a User table v2.0

Owned by Kim Stimpson
Last updated: 05 Oct, 2023
2 min read

Note:  Users will only be able to create their own tables in the 'staging' schema.

Admin users can create tables in any corporate schema.

Open QGIS

  1. Select Add PostGIS Layers... from the Layer menu.
     
  2. Click the New button under Connections to create a connection to your SDW.
    Create PostGIS Connection
  3. Enter the details for your SDW and the user that you created previously.
     
  4. Click Test Connect to make sure you have entered your details correctly and then click OK.
     
  5. Click Close to close the Add PostGIS Table(s) dialog.
     
  6. Now select the DB Manager > DB Manager from the Database menu.
     
  7. Expand the PostGIS node to display the Spatial Data Warehouse connection we have just created.
     
  8. Expand the node for your SDW and you will see any existing schemas e.g.
    View Existing Schemas

  9. Select the staging schema from the tree and then go to the Table menu and select Create Table.
    Create Table

  10. The first field needs to have a Name of ogc_fid and be Type serial. Then you may click Add field to add any other fields that you require.
  11. Select ogc_fid as the Primary key, check the Create geometry column box, select the geometry type from the list; enter the Name as wkb_geometry with an SRID of 27700.
  12. Click Create. 
  13. You should see an "everything went fine" dialog - click OK. Click Close.