Currently, I am trying to convert a geodb to a table in my PostgreSQL db with arcpy as such. I've tried both with the parcels table being created and the parcels table not being created
arcpy.TableToTable_conversion("C:/Temp/geodb.gdb\parcels", "C:/../postgresconn.sde", "parcels")
I know my ../postgresconn.sde works because I can do other things such as FeatureClassToFeatureClass_conversion via...
arcpy.FeatureClassToFeatureClass_conversion("C:/../postgresconn.sde\database.public.area", "C:/Temp/geodb.gdb", "area", "", "", "")
The problem is in the TableToTable method, is that I cannot use database.public.area (dots are not allowed in that argument string)
I have set my searchpath on the PostgreSQL sql side to point to database.public hoping that it would just reference that schema.
The error I am getting ...
arcgisscripting.ExecuteError: ERROR 000210: Cannot create output C:\...\postgresconn.sde\area
How can I make the method call TableToTable work in this scenario?