PostgreSQL 11 Administration Cookbook

How to do it...

Let's begin by opening the database and looking inside it:

1. You will already have a connection to your local database; if you haven't, you can create one by selecting New Connection in the Connections tab. This adds a new row with mostly empty fields, which you can fill before selecting Save Data:

If you open one of your connections, you can access the corresponding database server through the familiar tree view, with a right-click interface that, like pgAdmin, opens a set of available actions on that particular object.

2. Here is an example where we operate on a column of a table:

3. More generally, OmniDB offers graphical ...