Subscribe to our news:
 Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Shafiq Far: "Just wanted to let you know that I think the SQL Maestro for Postgres is excellent. We've tried a variety over the past few years and none are even close to yours. Well done".
More
Add your opinion
Customers
|
PostgreSQL Maestro online Help
Generation of updatable views
To generate updatable view,
| • | select the Object | Generate updatable views... main menu item (to create views for several tables) or use the corresponding popup menu item of the table's node at the Explorer tree (to create a view for one table). |
| • | Specify tables the views will be created for (in case of several tables). |
| • | Specify the abilities to be available on working with the view data. By default the views are generated for inserting, updating, and deleting of table data. |
| • | Adjust the name templates of views and corresponding triggers. |
| • | Select the action to perform after the generation. The created definitions can be copied to Clipboard, saved to a file, sent to SQL Script Editor or executed immediately. |
|
Company news 
Sep 26, 2025
New version comes with PostgreSQL 18 compatibility, introduces support for virtual generated columns, named NOT NULL constraints, NOT VALID property for NOT NULL constraints, NOT ENFORCED property for check and foreign key constraints and some other enhancements.
Sep 26, 2025
All software of our PostgreSQL family come now with PostgreSQL 18 compatibility.
Sep 30, 2024
New version comes with PostgreSQL 17 compatibility, upgraded SSH client and some other enhancements.
Resources
This article discloses the ways of role management provided by PostgreSQL Maestro. Learn how to create, edit, grant and carry out other manipulations with roles using our product.
Feature of the day
PostgreSQL Maestro permits to create a copy of a database object by dragging it from one database to another in the Explorer tree.
PostgreSQL Maestro introduces PL/pgSQL Debugger with traditional debugging features (breakpoints, Call stack, Watch list).
|
|
Download
Buy
