AnsweredAssumed Answered

Register Postgres table with geodatabase using Python

Question asked by flyinace on Sep 22, 2016
Latest reply on Sep 23, 2016 by Dan_Patterson

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?