To ensure that everything worked out fine, we will load the new Postgres layer in ArcGIS. Open ArcGis and the Catalog window .
Double- click Add Database Connection.
At Database Platform select PostgreSQL.
Instance is the address of your server ( in this example we use the local server ).
In Authentication Type, select Database authentication.
Enter the Postgres username and password.
Check the Postgis Database, in this case, postgis_22_sample.
Click OK A new connection appears in the Database connections
Under this connection you find all the tables included in the postgres database , with the name of the database (postgis_22_sample), the database (eg public) and the name of the table.
For each geographical layer, you have two occurrences: one for the table and another for the geographic layer.
Click and drag the second occurrence of the layer that we just created (ouessantclc_l93) to the legend window. The layer appears in ArcMap ( if everything worked ok ).
Is there a way to edit it ?
Honestly, I didn’t even try. I am tired of always having to look around the obstacles put in place by ESRI to discourage users from using opensource products.
There must be a way, but I opted to use Qgis and only have to worry about doing my job properly.
I have tried endlessly to connect postgres database to arcmap pro, and still no luck. Any help???!
I completely abandoned ArcGis and ESRI. I find it unacceptable to pay a lot of money to be forced to spend hours trying to do what an opensource software does in two clicks.
This guide is way easier than ArcGIS official guide, which includes tons of jargons and makes things more complicated. Kudos to you
Thanks a lot!