Softpedia >Mac >Developer Tools >PG Commander >  Changelog

PG Commander Changelog

What's new in PG Commander 1.5.9

Mar 5, 2016
  • Fixed host key checking when connecting to an SSH server.
  • Fixed problem when displaying error message.

New in PG Commander 1.5.8 (Mar 5, 2016)

  • Update to OpenSSL 1.0.2g
  • Update to libbsh2 1.7.0 (adds support for diffie-hellman-group-exchange-sha256)
  • Update bundled libpq to version 9.3.11

New in PG Commander 1.5.7 (Jul 13, 2015)

  • Update to OpenSSL 1.0.2d – Fixes CVE-2015-1793

New in PG Commander 1.5.6 (Jun 19, 2015)

  • Fixed a crash when opening a table with an exclusion constraint on a function.
  • Fixed a possible crash when loading database contents.
  • Updated libpq to 9.3.9
  • Updated OpenSSL to 1.0.1o
  • Updated libssh2 to 1.6.0

New in PG Commander 1.5.5 (Feb 18, 2015)

  • Fixed problems with table filters on Amazon RedShift
  • Fixed an issue where rows without primary key could not be saved when they use JSON, XML or geometry types
  • Numeric fields are no longer treated as strings

New in PG Commander 1.5.4 (Jan 27, 2015)

  • Fixed a hang when clearing a query with many results
  • Addressed occasional crashes on OS X 10.10.1 (often occurred when unplugging displays)

New in PG Commander 1.5.3 (Nov 14, 2014)

  • Windows now have more descriptive titles
  • Fixed an issue when connecting to pre-9.0 servers via SSH (including Redshift)
  • Fixed a bug where the text field was not activated when switching focus to the Terminal

New in PG Commander 1.5.2 (Oct 4, 2014)

  • Fixed an issue where PG Commander only showed some of the results in the SQL Terminal if downloading them took longer than approximately 50ms.
  • Fixed an issue where only the first line of error messages was shown.

New in PG Commander 1.5.1 (Sep 29, 2014)

  • Fixed an issue where the table icon grid didn't scroll on OS X 10.8.
  • Fixed a display bug when disabling SSH tunneling for a favorite on OS X 10.8
  • Fixed broken Copy command in Terminal

New in PG Commander 1.5 (Sep 29, 2014)

  • SQL Terminal:
  • Sort query results by clicking table header
  • Execute selection only
  • Execute queries again
  • Automatic Indentation in query editor
  • Tab key increases indentation of selected lines
  • Shift-Tab key decreases indentation
  • Queries now show execution time
  • Added a notification when a query completes while PG Commander is in the background
  • Clear individual executed queries
  • Queries now remember which file they were loaded from and automatically suggest original name when saving
  • Fixed a few annoying display bugs in terminal
  • Fixed an issue that would cause PG Commander to crash occasionally when executing a query
  • Improved autoscrolling behavior
  • Keyboard-interactive SSH authentication:
  • You can now connect via SSH servers that use keyboard-interactive instead of password authentication (eg. OS X). Additionally, PG Commander now supports connecting to servers that require multiple auth methods.
  • Full Screen Mode.
  • Database icons are now smaller to waste less space.
  • Long favorite names no longer break the UI
  • Fixed an issue where connecting to ‘localhost’ sometimes failed.
  • Improved support for connection URLs (introduces postgresql+ssh URL scheme for tunneling via SSH)

New in PG Commander 1.4.2 (Jul 14, 2014)

  • Addressed an issue where PG Commander would cause the discrete GPU to activate on some MacBooks.
  • Deleting Materialized Views now works as expected.
  • Added a warning when trying to connect via unix domain sockets.
  • Removed support for authentication via client side SSL in the Mac App Store version.

New in PG Commander 1.4.1 (Jul 2, 2014)

  • PG Commander now jumps to page 1 when a filter is applied.
  • Fixed a problem where PG Commander executed an incorrect query when the query text field was not in focus.

New in PG Commander 1.4 (Jul 2, 2014)

  • Cancel Queries in SQL Terminal
  • Fixed a problem where PG Commander may crash after closing an SSH connection.
  • Added support for authenticating with Client SSL certificates located in ~/.postgresql
  • The favorites window now closes automatically after establishing a connection.
  • Fixed incorrect keyboard shortcuts in the documentation
  • Upgraded to OpenSSL 1.0.1h to avoid the most recently published vulnerabilities.
  • Table View:
  • Persistent sort order.
  • Persistent column widths.
  • Rearrange columns.
  • Table Filters:
  • Filters are now persistent: When you open a table, PG Commander remembers the filters you used last time.
  • New Operators for text fields: ‘does not contain’, ‘is not exactly’.
  • New Operators for numeric fields: ≠, .
  • Filtering columns that contain percent signs, underscores and backslashes now works as expected.
  • Selecting ‘Custom SQL’ now autofills with the generated SQL of the filter.
  • Improved Exporting:
  • Conveniently export tables from context menu (in database view or in the sidebar)
  • Export directly from the table view using the ‘Export…’ command in the File menu. When exporting from the table view with active filters, only filtered rows are exported.
  • INTEGER and FLOAT types are now exported without quotes.
  • Row Editor Additions:
  • Added an option to insert DEFAULT in Boolean columns.
  • I made the popup menu in the row editor a lot smarter. It now shows options related to the column type:
  • FLOAT: Insert special values like Not-A-Number and Infinity.
  • DATE: Quickly insert todays date, or tomorrow, or yesterday.
  • UUID: Generate a random UUID value
  • JSON: Pretty Printing

New in PG Commander 1.3.0 (May 8, 2014)

  • Table Filters:
  • Quickly find rows that contain a string. By default, all columns are searched, but you can restrict the filter to a specific column. Combine multiple filters to quickly perform complex queries, or provide a custom WHERE clause.
  • Copy Rows as CSV / SQL:
  • Quickly copy rows from a table or from a query result as CSV or as SQL INSERT statements.
  • New Toolbar Buttons:
  • There are three new buttons by default: a back button, a forward button and a button to quickly open the terminal. Moreover, you can now customize the toolbar (right click) to add an optional up button and a reload button.
  • Keyboard Shortcuts:
  • New: ⌘⇧T opens the SQL Terminal
  • Changed: ⌘N opens the favorite window
  • Changed: ⌘⌥N opens a new window for the current connection
  • Sorry for messing with your muscle memory, but I think these choices are better in the long term. I also added a few tooltips to make keyboard shortcuts more discoverable (eg. ⌘↩︎ to execute a query).
  • Materialized Views are now also supported in PG Commander. They show up alongside tables & normal views in a green color.
  • Added more Retina icons
  • Pictures in bytea fields are now shown in a larger size
  • Removed unnecessary plain text warning when connecting to 127.0.0.1.
  • Fixed a problem where valid host keys were not accepted when connecting via SSH

New in PG Commander 1.2.3 (Apr 18, 2014)

  • Fixed crash on Mac OS 10.8

New in PG Commander 1.2.2 (Apr 10, 2014)

  • Updated libpq to version 9.3.4
  • Updated OpenSSL to 1.0.1g to address heartbleed bug

New in PG Commander 1.2.1 (Feb 18, 2014)

  • Improved reload behavior
  • Fixed 2 issues with SSH tunnels