I have seen a number of posts similar to this but with no resolution.
I am experimenting with GDAL commands and am fairly new to it however when using a PostgreSQL database connection I am getting the following errors:
FAILURE: Unable to open datasource `PG:host=127.0.0.1 port=5432 dbname=postgres user=postgres password=*******' with the following drivers. (Lists all drivers)
ERROR 1: Unable to find driver `PostgreSQL
ogr2ogr -overwrite -update -f PostgreSQL PG:"dbname='cadcorp' host='localhost' port='5432' user='postgres' password='********'" C:\Users\tommyh\Desktop\data\merged.shp -nlt POLYGON -nln gdaltestupload -progress
when I run gdalinfo --formats the list doesn't PostgreSQL so I guess I can see why the PostgreSQL connection isn't working compared to when I use a SQL Server connection MMSQLSpatial which is in the formats list.
I have set the environment variables:
My GDAL version is:
gdalinfo --version GDAL 2.2.3, released 2017/11/20
Running through the command prompt on Windows 10.
Any ideas on what I may be missing or need to do?