In pgadmin, what is the meaning of the small right arrow on the table tree? please refer to below image for table 'meetingtype_r'
2 Answers
I was not able to locate any documentation regarding the icons in pgadmin, but based on the icon table-inherited.svg, it means that the table is inherited.
check web\pgadmin\browser\server_groups\servers\databases\schemas\tables\static\img\
Edited:
Another way to confirm my conclusion is to run this query (thanks to Michael Krelin ) and you will see the name of your table with an inheritance appear
SELECT pg_inherits.*, c.relname AS child, p.relname AS parent
FROM
pg_inherits JOIN pg_class AS c ON (inhrelid=c.oid)
JOIN pg_class as p ON (inhparent=p.oid);
One possible way that this icon appear is when a table is defined as a time series table, then pgadmin system is creating hypertable chunks under the _timescaledb_internal schema.
There are no confirmed answer.
There is an open thread in postgres support in below link. you can follow for most updated answer.
Some of the options that I have already validated.
- its not a icon to show inheritance
- its not an icon for trigger
one of the comments that I could not totally reject is below:
" My thought is that icon started appearing with the expanded support for partitioned tables, so is this a table that is partitioned or a table that holds partitioned data "
Related