Browse, find and edit objects

Browsing database objects

PostgreSQL object browser

The object tree displays the objects in the database hierarchical as layed out on the server. Some leaf objects such as columns, indexes etc don't get their own item in the browser, but are displayed on pages at the parent object they belong to.

Note that only the most commonly used are supported so far; more to come soon.

Finding objects

The standard Admin4 Find Objects feature is enhanced in this module, searching the database for known objects whose name matches the text fragments given in the find field. The object's name will have to match all text fragments. If the first search fragment contains a ".", the part before the dot is interpreted as namespace fragment.

The database to search is deducted from the object currently selected. If no database is determined, i.e. the server itself is selected, the find function will fall back to the standard Admin4 behaviour scanning the object browser tree only.

Editing database objects

Database objects can be edited by double-clicking them in the browser, or clicking the line on the page.

Note that editing on many objects isn't supported so far; this will be implemented soon.

Favourites

If the server is properly instrumented (see next section), object favourites are available.

In databases with many objects, it can be cumbersome to locate an object. You can mark objects you're accessing frequently as favourite using the context menu. After that, the object will appear under "Favourites" as well and it is accessible both from its favourite location as well as down the object tree.