Hello,
Can someone please tell me if PostgreSQL/PostGIS (or any SQL RDMS) can be used on file geodatabases (rather than on SDE databases) with ArcGIS Pro 3.x? I just started a new position and have an ArcGIS Professional Basic license, which doesn't include use of SDE. I'd like to work with my GIS data in a RDMS but have never tried with file geodatabases before.
Thanks,
Nicole
Solved! Go to Solution.
It was right there:
(i.e., generate SQL on the fly to execute in the database through a cursor)
I also wrote "much more difficult". If you haven't spent the past six months generating `psql` INSERT statements in a Python DA SearchCursor query, it's still "possible", just a heck of a lot of work. Way more work than dragging and dropping a FGDB feature class into a connection file with a Standard or Advanced seat license (against a properly prepared PG database with a lower-case schema that matches the login and has the correct permissions).
- V
I gotcha--good to know. Thank you for the input.
The answer that this quoted was probably a better candidate for "Solution" marking.