OmniDB
2.17.0

Contents:

  • 1. Introduction
  • 2. Installation
  • 3. Creating Users and Connections
  • 4. Managing Databases
  • 5. Creating, Changing and Removing Tables
  • 6. Managing Table Data
  • 7. Writing SQL Queries
  • 8. Visualizing Query Plans
  • 9. Visualizing Data
  • 10. Managing other Elements
  • 11. Additional Features
  • 12. OmniDB Config Tool
  • 13. Writing and Debugging PL/pgSQL Functions
  • 14. Monitoring Dashboard
  • 15. Logical Replication
  • 16. pglogical
  • 17. Postgres-BDR
  • 18. Postgres-XL
  • 19. Deploying omnidb-server
  • 20. Console Tab
  • 21. Plugin System
  • 22. Advanced Object Search
  • 23. Debugger Plugin Installation
  • 23.1. Linux Installation
  • 23.2. Windows Installation
  • 23.3. FreeBSD Installation
  • 23.4. MacOSX Installation
  • 23.5. Post-installation steps ** REQUIRED **
OmniDB
  • Docs »
  • 22. Advanced Object Search
  • Edit on GitHub

22. Advanced Object Search¶

OmniDB 2.9 introduces the a Advanced Object Search feature, allowing users to use an advanced pattern matching to search database objects and tables data. The feature allows to use the default SQL LIKE operator and also complex regular expressions.

You can access the Advanced Object Search feature by right clicking in a specific database node in the tree:

https://raw.githubusercontent.com/OmniDB/doc/master/img/image_196.png

The interface allows you to filter categories of objects, schemas where searchs will be executed and also to limit the search space when the Data category is selected, so you search for a pattern in a subset of tables:

https://raw.githubusercontent.com/OmniDB/doc/master/img/image_197.png

After filling the fields and running OmniDB will perform the search using several threads that will speed up the process by running in parallel (It is customizable. For more info, see chapter 19 - Deploying OmniDB).

When the search is finished OmniDB will display the result in a tree:

https://raw.githubusercontent.com/OmniDB/doc/master/img/image_198.png

For more details about the search in each category, right click the desired node and select ‘See More’. OmniDB will open a query tab with the SQL command used to perform that specific search. Just run the command to get the results:

https://raw.githubusercontent.com/OmniDB/doc/master/img/image_199.png https://raw.githubusercontent.com/OmniDB/doc/master/img/image_200.png

Next Previous

© Copyright The OmniDB Team Revision a6d692fb.

Built with Sphinx using a theme provided by Read the Docs.
Read the Docs v: 2.17.0
Versions
latest
stable
2.17.0
dev
Downloads
On Read the Docs
Project Home
Builds

Free document hosting provided by Read the Docs.