The lower right side contains a reverse engineered SQL script that allows you to copy it to any editor using cut and paste, or simply save it to a new file.īy using the Query tool, you are able to execute arbitrary SQL commands with ease. Tabs such as ‘Properties’, ‘Statistics’, ‘Dependencies’ and ‘Dependents’ enable you to get a better overview of the selected object. The upper right side displays detailed information about the currently selected object available in the tree view. The left panel of the application displays a hierarchical tree with all the available servers and the objects they contain, such as tablespaces, schemas, catalogs and triggers. You can easily create objects, delete and edit existing ones, manage multiple tables and perform actions such as delete, insert, drop or alter. In the main window you are able to view the structure of the available databases. The application comes with an intuitive and user-friendly interface and with well-organized menus. The installation process does not require you to perform any advanced configurations, however, when you add a password (which is mandatory when you need to connect to the default server), you need to memorize it, otherwise you will not be able to use PostgreSQL. What’s more, the program comes with support for multibyte character encodings and it is locale-aware for sorting all the scripts available in one file. PostgreSQL is a comprehensive and practical database design and management system geared toward administrators who need to organize and control multiple databases, run SQL queries, as well as create new triggers and attributes.ĭesigned as an enterprise class database, PostgreSQL boasts powerful features such as point in time recovery, asynchronous replication, nested transactions and tablespaces, to name a few.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |