Creating a User table V1.5
Note: Users will only be able to create their own tables in the 'staging' schema.
Open QGIS
Select Add PostGIS Layers... from the Layer menu.
Click the New button under Connections to create a connection to your SDW.
Enter the details for your SDW and the admin user that you created previously. See above screenshot for details.
Click Test Connect to make sure you have entered your details correctly and then click OK.
Click Close to close the Add PostGIS Table(s) dialog.
Now select the DB Manager > DB Manager from the Database menu.
Expand the PostGIS node to display the Spatial Data Warehouse connection we have just created.
Expand the node for your SDW and you will see any existing schemas e.g.
Select the staging schema from the tree and then go to the Table menu and select Create Table.
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.
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.
Click Create. You should see an "everything went fine" dialog - click OK.
Click Close.