PROBLEM
In PostgreSQL, a table is created with a unique ID field. The table is stored in a schema owned by a login user with the same name as the schema. In pgAdmin, the table is visible and can be queried. In the example shown in the image of pgAdmin below, this table is called "TESTTABLE".
However in ArcGIS Pro, the new table is not visible, even when connecting the PostgreSQL database as the owner of the table, as shown in the next image.
The table name has uppercase characters. In PostgreSQL, using uppercase or mixed-case characters in table names requires that all queries be constructed with double quotes. This is not supported in ArcGIS for PostgreSQL. When connecting to a PostgreSQL database from ArcGIS Pro, tables using upper or mixed-case characters are not visible.
Change the table name to all lowercase.
Article ID: 000032184
Get help from ArcGIS experts
Download the Esri Support App