pgAdmin3

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. The application may be used on Linux, FreeBSD, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform, as well as commercial and derived versions of PostgreSQL such as Postgres Plus Advanced Server and Greenplum database.

pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional drivers are required to communicate with the database server.

pgAdmin is developed by a community of PostgreSQL experts around the world and is available in more than a dozen languages. It is Free Software released under the PostgreSQL License.

• Resolving the inconsistency of preservation of modified information of the columns, while adding/editing a table from the table dialog
• Add missing nodes to graphical explain plan
• Fix the Resource Groups dialog - separated the statements, which can not be ran in single transaction
• Support for Slony-I 2.2+ with PostgreSQL 9.3+
• Support smallserial columns in Edit Data Window
• Restore the user specified size on the grid (which contains the result) in Query windows to fix an issue related to the column size is too narrow on subsequent Explain execution
• Empty the Undo/Redo history everytime new file is opened
• Added accelerator F8 for 'Execute to file' in the Query window
• Beautify the query shown in the SQL pane for the functions having multiple arguments by adding new lines with small modification by me
• Check for the columnlist for the UPDATE OF syntax on trigger also works with PPAS 9.5+
• Proper saving of columns width in the server status window
• Fix support for triggers with inline code on PPAS
• CHECK OPTION is applicable to the views only, and not the materialized views
• Prevent a crash during the update of the macro or favourite list
• Allow quick injectection of favourites by name
• Fix handling of saving macros after pasting a query in the box
• 2014-07-14 GL 1.18.2 Fix SQL for GRANT on a sequence.
• Fix handling of char() columns in the Edit Grid
• Support the new check_option parameter of views
• Handle the 9.4 MOVE clause of ALTER TABLESPACE
• Add a new action menu to refresh a materialized view
• Support the new 9.4 columns in pg_stat_activity
• Save search options for next time
• Ensure Favourite queries are only saved when the OK button is pressed
• Fix an issue refreshing functions in PPAS packages
• Improve handling of lost connections
• Allow searching for database objects by comment and definition content
• Add support for Resource Groups in PPAS 9.4
• Add Save and Exit shortcut keys to the edit grid