...
- Select Toolbox from the Processing menu. The Processing Toolbox panel opens on the right hand side of QGIS e.g.
- Expand the GDAL/OGR entry and then the OGR Miscellaneous entry.
- Double click on the Import Vector into PostGIS database (new connection) entry.
- Now you have a whole lot plethora of Parameters you can specify.
- Select your Input Layer and Output geometry type. Enter your database details, Primary key and Geometry column name as before.
- Now scroll further down the list and you can specify Additional creation options. Enter PRECISION=NO e.g.
- Click Run to Import your Layer.
- Make another cup of tea.