Subscribe to our news:
 Partners
Testimonials
Patric Michael: "Thank you for a wonderful product, and all the hard work you've obviously taken".
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 
Aug 19, 2017
New version introduces support for a number of PostgreSQL 10 new features including table partitioning and identity columns, custom colors for server nodes, database profile usage statistics, and some other interface enhancements.
Jun 27, 2016
New version comes with PostgreSQL 9.6 compatibility, support for row-level security policies and a number of other PostgreSQL 9.5 new features, updated BLOB Editor and other useful things.
Apr 2, 2015
New version introduces enhanced Tablespace Editor, improved SQL Formatter, new encryption algorithms in data grids, updated data export and data import tools and some other new features.
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 allows you to save frequently used queries to profiles.
PostgreSQL Maestro introduces PL/pgSQL Debugger with traditional debugging features (breakpoints, Call stack, Watch list).
|
|
Download
Buy
