I just noticed that DbVis does not show all PG entities. At least rules are missing. While there is a general folder in the object tree, it is empty.
In the object view, there is neither rule tab or for views nor in the object tree under the specific view. The table object of the tree has the point for rules. For tables, they might show up in the general folder, I did not check. However, to me, it seems at least as important to have them in the object view for sure in views. It is not uncommon to me to place a rule on a view to make it an insert on the underlying tables instead. This is said to be faster than triggers. I am aware that it is not recommended to create rules for updates (and deletes?) because their behaviour is anything but straight forward. I use triggers for that instead. However, on views, they do not show up either.
To me, DBeaver seems to be more concise in this point.
BTW, as triggers and rules cannot exist without an underlying object, I do not see much point in having a general folder.
Thiemo Kellner
Hej
I just noticed that DbVis does not show all PG entities. At least rules are missing. While there is a general folder in the object tree, it is empty.
In the object view, there is neither rule tab or for views nor in the object tree under the specific view. The table object of the tree has the point for rules. For tables, they might show up in the general folder, I did not check. However, to me, it seems at least as important to have them in the object view for sure in views. It is not uncommon to me to place a rule on a view to make it an insert on the underlying tables instead. This is said to be faster than triggers. I am aware that it is not recommended to create rules for updates (and deletes?) because their behaviour is anything but straight forward. I use triggers for that instead. However, on views, they do not show up either.