How to query geodatabase system tables using PostgreSQL to result this:
schema, table, column, domain name
I found this, but nothing for PostgreSQL https://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/query-system-tables-with-sql.htm
Does anyone have an idea?
-
As this is more a database question than a GIS question (even if this is a spatial database) you may get more answer on dba.stackexchange.comJ.R– J.R2020年10月09日 11:05:16 +00:00Commented Oct 9, 2020 at 11:05
-
A somewhat related oracle post here: gis.stackexchange.com/questions/215618/…User1974– User19742020年10月10日 14:37:54 +00:00Commented Oct 10, 2020 at 14:37
-
How far can you get by poking around the GDB tables in your SQL client? desktop.arcgis.com/en/arcmap/10.3/manage-data/…, desktop.arcgis.com/en/arcmap/10.3/manage-data/…User1974– User19742020年10月10日 14:39:50 +00:00Commented Oct 10, 2020 at 14:39
-
2@J.R The fourth element in the list, domain name, is only available in XML metadata within the Enterprise geodatabase tables, so this is an Esri-specific question.Vince– Vince2020年10月20日 19:05:27 +00:00Commented Oct 20, 2020 at 19:05
lang-sql