topic Re: Register Postgres table with geodatabase using Python in Python Questions

Register Postgres table with geodatabase using Python

JeremyKnaggs — Thu, 22 Sep 2016 20:02:29 GMT

How do I use Python and arcpy (or sql commands) to register a new postgres database table with geodatabase? I've programmatically created a new table which, among other things, has an st_geometery column but before I can view this table in ArcDesktop I always need manually "register with a geodatabase". I believe this has to do with the need to have an "objectid".. I've tried creating a column called "objectid" and making sure it contains a not null integer but I still have to register the table...Surely there must be a way to bypass this manual step and just use python to create the table and do the "registration". How can this be accomplished?

Re: Register Postgres table with geodatabase using Python

DanPatterson_Retired — Thu, 22 Sep 2016 20:53:29 GMT

I don't use this in any of my workflows, but is this the tool you use in arctoolbox? or is this a catalog process only

If it is this, the code sample might help

Then there was this thing Create Unregistered Table—Help | ArcGIS for Desktop

and this Add Incrementing ID Field—Help | ArcGIS for Desktop

hopefully you can cobble something together

Re: Register Postgres table with geodatabase using Python

JeremyKnaggs — Fri, 23 Sep 2016 15:38:56 GMT

Thanks Dan. Using the "RegisterWithGeodatabase_management" seemed to do the trick. I'm not really using any tools in arctool box or arc catalog. I was just looking for a way to create and write to databases that various GIS tools can read from. ArcDesktop seemed to refuse to map any geometry in the database unless i first register the table as a geo-database. Not sure why the extra step is necessary, but I'll just go with it.

Re: Register Postgres table with geodatabase using Python

DanPatterson_Retired — Fri, 23 Sep 2016 16:10:48 GMT

jJeremy, good... The functionality of the tool can be accessed through python, should you decide to continue on that route... just see the code snippets at the bottom of every tool in arctoolbox.