Working with a Postgres Server - List by schemas?

Question

I have connected my Postgres server to ArcGIS Pro, but when I view the data in the Catalog Panel it displays all the tables in a single list. Due to the amount of tables this displays, this is unusable. Is there any way to have schema names that can be expanded to show the tables within displayed instead?

George_Thompson · Answer

I would recommend creating an ArcGIS Idea, https://community.esri.com/t5/custom/page/page-id/arcgis-ideas, for this. You can also search to see if one is already submitted.

jamieatland · Answer

Hi,

Yes, that's what I am seeing. I can see every table in our database, I have permission on all of them, it's just so many tables that it's incredibly hard to work with. By contrast, in QGIS by default I instead get a list of schemas which can be collapsed to their given tables, which makes it much easier to quickly pin-point the data you need.

If it's not possible in Arc then that's all I really need to have confirmed, so thanks! But maybe this should be added as an option?

George_Thompson · Answer

I have not seen a way to do this. In Pro it will show you all the tables that you have access to, including from multiple schemas. Pro does this with other RDBMS's like SQL Server.

Are you connecting with an account that has the "superuser" privilege?

If I connect as my data owner (data), I only see the tables in my schema. This user only has access to this schema, limited permissions

If I connect as my postgres super user, I can see data in the other schemas:

Is this what you are also seeing?

These are not Enterprise Geodatabases, just PostgreSQL databases with PostGIS enabled.