If I turn on schema groupings for postgresql DB, I see the following pg_ schemas:
- pg_catalog
- pg_temp_1
- pg_toast
- pg_toast_temp_1
When I drill into each of these schemas, they all show the same system tables. Review the query we're using to extract the schema information and see if there is a bug.
As for how the table/system table/view/system view nodes work, they may cause some confusion. If you add any tables or views to pg_catalog or information schema, these tables/views would fall under the system tables/views. system table/view folders are duplicated in all the schemas.
If we where to change this, the only viable possibility would be to remove system tables/view node when grouping by schema is on and then extract the tables and views by the schema owner only. This would just show the tables/views owned by the schema in there table/view folder.
Lets go ahead & drop pg_temp* and pg_toast*
pgAdmin does not display these as well.
http://www.postgresql.org/message-id/4F998738.9030303@agliodbs.com
Lets go ahead & drop pg_temp* and pg_toast*
pgAdmin does not display these as well.
http://www.postgresql.org/message-id/4F998738.9030303@agliodbs.com
if schema grouping is on, we no longer display schemas that start with pg_temp or pg_toast.
Same code is also placed for paraccel & greenplum
if schema grouping is on, we no longer display schemas that start with pg_temp or pg_toast.
Same code is also placed for paraccel & greenplum
Issue #8744 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 13.0.0-9 |
No time estimate |
As for how the table/system table/view/system view nodes work, they may cause some confusion. If you add any tables or views to pg_catalog or information schema, these tables/views would fall under the system tables/views. system table/view folders are duplicated in all the schemas.
If we where to change this, the only viable possibility would be to remove system tables/view node when grouping by schema is on and then extract the tables and views by the schema owner only. This would just show the tables/views owned by the schema in there table/view folder.