Virtual views

If you need to monitor the result set of a certain SQL statement that you run regularly, use a virtual view. Virtual view lets you have the result set available in the Database tool window, and that data will not be stored in the database.

For a virtual view, apart from SELECT queries, you can also use statements like show processlist for MySQL or exec sp_who2 for Microsoft SQL Server.

For example, to have a list of current database connections for a PostgreSQL database, create a virtual view with the following query:

        SELECT *
FROM pg_stat_activity;
    

The virtual view with the result set of your query will be available in the Database tool window as a virtual object.

Virtual views can be seen in the Database tool window. You can see a reference on node and object icons in the Icons for data sources and their elements chapter of Database window topic.

Create a virtual view

In the Database tool window ( View | Tool Windows | Database) , expand the data source tree until the node of a schema.
Right-click a schema and select New | Virtual View.
In the Create dialog that opens, enter the name of your virtual view in the Name field.
Type your SQL statement in the Query field.
Click OK.

Last modified: 21 December 2022