SQL Manager for PostgreSQL Portable

SQL Manager for PostgreSQL Portable is a comprehensive and suitable solution especially intended for database administrators who need to manage and organize tables, functions, domains, triggers and procedures effortlessly.
Adopting a straightforward approach, the application also helps you to create new PostgreSQL databases, manage the existing ones, organize permissions and execute SQL scripts.
When you open SQL Manager for PostgreSQL Portable for the first time, you are required to register a new database, otherwise you won’t be able to work with your scripts.
The Database menu enables you to create a new connection by setting up the proper parameters, selecting databases and customizing their specific options. After that, the Databases panel, located in the left pane of the application displays all of the tables alongside their views, functions, triggers, queries and reports.
Additionally, you can navigate through categories such as ‘Domains’, ‘Triggers’, ‘Indices’, ‘Composite Types’, ‘Aggregates’ and ‘Local Scripts’, to name a few.
When you right-click on the identified host, you are able to view the status of the current server, manage all the available users and groups, backup data, change the view mode etc.
In case you want to write and execute SQL scripts, you can easily open a new ‘SQL Editor’ window, located in the Tools menu, from where you are able to gather data from different tables by using specialized scripts. Also, the ‘Show Query Builder’ option allows you to load a new diagram, map tables via their primary keys and create complex SQL scripts automatically.
What’s more, SQL Manager for PostgreSQL Portable enables you to compare two different databases and create a script in order to deploy changes from one database into another one. An intuitive wizard will guide you through the process of specifying the source and the target database, then selecting the type of synchronization script.
Thanks to its portability characteristic, you can take the application with you anywhere you want. It does not require you to install it and allows you to run it from your USB stick or your desktop, completely removing the program just by deleting the containing folder.
To wrap it up, SQL Manager for PostgreSQL Portable proves to be a steady solution when it comes to managing and organizing your PostgreSQL databases, procedures and triggers, rollbacking a database structure to any previous version or simply executing SQL scripts.