Subscribe to our news:

 Partners
 Testimonials
Jad Cooper: "Your program is the best. I have only few hours but now I make very great data for my meeting".
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".
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. |

|
|
SQL Maestro Group wish you a Happy New Year!
|
We're glad to grant you a 20% discount for all our products and bundles till January 20!
|
 Company news 
Oct 14, 2020
All products of our PostgreSQL family come now with PostgreSQL 13 compatibility.
Oct 18, 2019
New version comes with PostgreSQL 12 compatibility, introduces support for stored generated columns, using of planner support functions in functions and some other enhancements.
Dec 20, 2018
New version comes with PostgreSQL 11 compatibility, introduces support for hash-partitioned tables, procedures and a number of other PostgreSQL 11 new features, updated SSH client equipped with more secure key exchange algorithms, new wizard for database restoring from backup source 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 provides you with an ability to export data to any of 14 available data formats.
PostgreSQL Maestro introduces Schema Editor designed for schema subitems and schema permissions management.
|
|