New Features: - Partitioned tables are now grouped in the sidebar - Postico shows the source table in the tooltip of view column headers Fixes: - Numeric columns with negative scale are now supported - When creating a new tab with an empty query file, Postico now connects to the current database instead of the default database - Inherited constraints are no longer included in CREATE TABLE statements - I also improved a lot of state restoration code - a possible naming conflict with the new "Trie" system class was resolved

An all new toolbar design that looks great on macOS Tahoe!

- Add support for generated virtual columns (PostgreSQL 18) - Automatically trim whitespace from host field and others - Don't move keyboard focus to search field when loading tables (this interfered with keyboard navigation and type select in the sidebar) - More reliable error handling: Postico now catches exceptions gracefully and displays a dialog - Fixed an issue where the schema name was not quoted when editing indices - Fixed a bug where functions on CockroachDB were not displayed - Fixed crash when trying to copy the connection URL and the host name contains special characters - Fixed a race condition when accessing the SSH host key fingerprint - Fixed a bug when double clicking query view results - Fixed a few very rare crashes

Fixed an issue where saved servers disappeared for some users

New Features and changes: - Quick Filter Actions: You can now right-click a value to show only rows with the same value, or to hide rows with that value - Added "Copy Name with Schema" command to sidebar context menu - Postico no longer uses escape string literals (like E'...') when copying INSERT statement Bug Fixes and improvements: - Fixed a problem with adding/removing files from the SQL query sidebar - Upgraded to Swift 6 and refactored some code to use modern Swift Concurrency - Fixed a lot of crashes - New version of the Autoupdate framework (Sparkle)

- prevent a crash when moving the mouse over "is in list" filter on macOS Sequoia on Intel Macs - "bytea" columns: Replaced the "Crockford" style with "ULID". The ULID style is also a Crockford encoding, but the bits are right-aligned to match ULIDs - fixed a rare crash that could happen when dragging files on the Postico window - improved error reporting and minor fixes

Bug Fixes: - fixed a bug where Postico failed to import CSV files with lines > 1MB - prevent the query editor from disappearing by setting a minimum height New Feature: - added an Internet Access Policy (used by the firewall app Little Snitch)

New Features: - Added a new setting that allows you to display binary values ("bytea") as Hex, Base64, or Crockford's Base32 - Multi-column sort! Sometimes a single column just isn't enough. Postico can now sort tables by multiple columns. Just hold down the option key when clicking the column to sort. - Sort NULLSs first or last. Right click the column header and make your choice. - More ways to organise your queries: Postico now supports symbolic links and aliases. Small Improvements: - Added a command to copy all values in a column - Added a way to add a device name when activating multi-user licenses - Add support for "nulls not distinct" indics - Postico now has a command for generating UUIDv7 values - Row counts are now formatted according to system settings (eg. 1,000,000 rows instead of 1000000 rows) - Escape key no longer ends full screen mode - Better support for functions & stored procdedures on Amazon Redshift Bug Fixes: - Fixed a few crashes eg. when refreshing while the mouse is inside the "is in list" filter text field - Fixed bug when adding columns with comments - Better error messages when autocomplete fails

Bug Fixes: - Fixed a crash when clicking the database in the breadcrumb control - Fixed a bug where "Custom SQL" filters sometimes did not work - Fixed a glitch when displaying error messages - Fixed a crash when reading a damaged server properties file Improvements for SSH Tunnels: - Fixed a problem where Postico incorrectly handled closed SSH channels, leading to an issue where the SSH server would sometimes disconnect after a query was cancelled - Improved SSH Tunnel error reporting Fixed a few memory leaks: - Postico now closes all connections used by a window when clicking the "disconnect" button - Fixed retain cycles that lead to connections staying open even after the window was closed - Fixed a memory leak during CSV import: Temporary memory was freed only at the end of the import, which would cause Postico to run out of memory when importing large files. Postico can now read passwords from the ~/.pgpass file. For more information, see the PostgreSQL documentation. And finally, Postico 2 now remembers column widths in table view!

- Add "delete" and "share" buttons for servers - CMD-R no longer clears query results - Fixed a bug where macOS keeps showing keychain dialogs - Fixed a bug where Postico said "The server returned an unexpected query result" when creating a table with comments - Reduce unnecessary autosaves (this might fix an issue where Postico suddenly reverts changes in the SQL query editor)