SQLPro for PostgreSQL

+ Fixed an issue where new connections were defaulting to read-only.

+ Fixed an issue with setting default values via the table designer.
+ Fixed an issue with changing a columns nullability via the table designer.
+ Fixed an issue with importing arrays. [#425](https://github.com/hankinsoft/SQLPro/issues/425)
+ Fixed an issue with importing NULL timestamps. [#424](https://github.com/hankinsoft/SQLPro/issues/424)
+ Fixed an issue which could cause crashes when skipping columns during CSV import. [#424](https://github.com/hankinsoft/SQLPro/issues/424)
+ Fixed an issue which could cause crashes when cancelling a query or closing an tab with an active query running. [#416](https://github.com/hankinsoft/SQLPro/issues/416)
+ Fixed an issue where right clicking on an escaped table name in the query editor would sometimes result in a 'No object selected' issue. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
+ Fixed an issue with keyboard shortcuts would not save properly if tab characters were used. [#403](https://github.com/hankinsoft/SQLPro/issues/403)
+ Fixed an issue where when importing from CSV, the focused table may not be defaulted. [#405](https://github.com/hankinsoft/SQLPro/issues/405)
+ Increased internal SQLite version used. [#412](https://github.com/hankinsoft/SQLPro/issues/412)
+ Fixed an issue with tabs in the query editor. [#395](https://github.com/hankinsoft/SQLPro/issues/395)
+ Improvements with the History popup. [#400](https://github.com/hankinsoft/SQLPro/issues/400)
+ Alias improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
+ When modifying rows via the results-grid there is now an 'Apply' button, so that changes can be applied without needing to preview first.
+ Result messages are now monospaced.
+ Result messages now uses the same font size as the query text editor.
+ Result error messages are now more of a 'whiteish-pink' when using a dark theme (a bit easier on the eyes).
+ Fixed an issue where 'Copy as Insert' did not escape table names. [#390](https://github.com/hankinsoft/SQLPro/issues/390)
+ Additional improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
+ Added a 'Read-only' intent option (currently for MSSQL). When this option is enabled, all DROP, TRUNCATE, DELETE, UPDATE, INSERT, etc related UI is hidden from the user. This will NOT prevent the user from creating and running their own SQL commands. [#386](https://github.com/hankinsoft/SQLPro/issues/386)
+ Additional improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)

+ Fixed a crash some users were seeing when opening queries.
+ Fix for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
+ You can now add custom connection groups.
+ You can now expand and collapse connection groups.
+ Fix for 'blue turds' in query text view. [via twitter](https://twitter.com/danielpunkass/status/1236062931097473024?s=21)

+ Fixed an issue where autocomplete may sometimes escape object object when not required. [346](https://github.com/hankinsoft/SQLPro/issues/346)
Table designer has been re-written - changes are now previewed before being applied.
Table designer now includes comments for tables, columns, indexes, triggers and foreign keys.
+ Added support for SSH Tunnel keyboard authentication. [#367](https://github.com/hankinsoft/SQLPro/issues/367)
+ Fixed an issue when CSV importing when column name case did not match the csv file.
Fixed an issue when CSV importing with empty CSV rows.
+ Failed CSV imports now have a 'view insert' option which displays the failed insert statement.
+ Fixed an issue where having cap-locks on would disable tab indent/un-indent. [#335](https://github.com/hankinsoft/SQLPro/issues/335)
+ Added support for ed25519 keys.
+ Redshift - Support for seeing non schema bound columns in views (database tree).
+ Fixed a crash with autocomplete.
+ SSH Tunnel dialog now has a 'Validate' option to verify private key and password.
+ Redshift - Fixed an issue where tables were not loading.

+ You can now paste a postgres URI into the host field. [#364](https://github.com/hankinsoft/SQLPro/issues/364)
+ Fixed an issue where the SQL beautifier would add an extra space at the end of lines. [#362](https://github.com/hankinsoft/SQLPro/issues/362)
+ Fixed an issue where dropping procedures would try and run a drop function script. [#352](hhttps://github.com/hankinsoft/SQLPro/issues/352)
+ If you select a Table or Column in the database tree, hitting Copy (via ctrl-c or menu items) will copy the table schema/name or column name to the clipboard.
+ Fixed a crash that could occur when clicking on Foreign Keys in the results data grid.
+ Improved autocomplete with 'order by' clause. Now limits to tables used in the query.
+ Autocomplete is now a background operation. If for some reason the autocomplete is slow it will no longer freeze the main UI thread. [#334](https://github.com/hankinsoft/SQLPro/issues/334).
+ Fixed an issue where refreshing the root server node would do nothing. [#350](https://github.com/hankinsoft/SQLPro/issues/350)
+ Fixed an issue where closing tabs may not disconnect the client. [#353](https://github.com/hankinsoft/SQLPro/issues/353)
+ Postgres inherited tables are now beneath their parents node in the database tree. [#355](https://github.com/hankinsoft/SQLPro/issues/355)
+ Fixed a crash that could when inserting a new row.
+ Improvements to database search.
+ Fixed an issue with CSV import into existing table.
+ Fixed an issue where schemas were being displayed on object in the database tree when 'Group schemas in database tree' was enabled.
+ Foreign tables are now available in the database tree.
+ Fixed an issue with state restoration. The database tree was not getting preserved when you disconnect from a database.
+ Fixed a crash that could occur when duplicating tables.
+ Fixed an issue when duplicating tables where the source table was not always the one duplicated if the source table was not the table select in the database tree.
+ Fixed an issue which could cause crashes when inserting into a result set.
+ Improvements with CSV imports.

+ Fixed an issue with state restoration. The database tree was not getting preserved when you disconnect from a database.
+ Fixed a crash that could occur when duplicating tables.
+ Fixed an issue when duplicating tables where the source table was not always the one duplicated if the source table was not the table select in the database tree.
+ Fixed an issue which could cause crashes when inserting into a result set.
+ Updated to the latest Oracle library.
+ Improvements with CSV imports.
+ Fixed an issue with the 'Disable' option of 'Execute query in cursor range' where the current query would still be highlighted when modifying a query.

+ Performance improvements for autocomplete.
+ Fixed a crash which could occur with autocomplete.
+ 'Execute button' now has additional options.
+ Performance improvements for autocomplete.
+ Improvements to state restore where not all tabs were always being restored.
+ Result grid editing - Primary keys are no longer required (but are still encouraged).
+ Result grid editing - When editing cells, changes are no longer applied until the new 'Preview and Apply' button has been pressed. A discard button is also available.
+ Result grid editing - Shift-Tab now works to move to the previous cell (and regular tab now works better due to the previously mentioned change).
+ Importing CSVs into Oracle is now quicker to list tables.
+ Improved background drawing in query text view when query execution style is 'execute query in cursor range'.
+ Quoted column names are now handled by syntax highlighting.
+ Creating a table in Postgres no longer displays as reversed schema/table name.
+ Fixed an issue which could cause some PostgreSQL connections to crash on connection.
+ Fixed an issue where the 'databases' dropdown in the new/edit connection window could cause a crash.
+ Fixed an issue with could sometimes cause crashes when typing a query.

### SQLPro 2019.52
+ **[macOS]** Fixed multiple issues with state restoration.
+ **[macOS]** Many buttons now respect the systems accent color (macOS 10.14 and above).

### SQLPro 2019.51
+ **[macOS]** Fixed compatibility with macOS 10.11 and MSSQL connections (connecting to MSSQL would crash).

### SQLPro 2019.50
+ **[macOS]** Fixed an issue where CTE columns may display incorrect column names. [#314](https://github.com/hankinsoft/SQLPro/issues/314)
+ **[macOS]** Fixed an issue autocomplete window may display below the bottom of the screen. [#315](https://github.com/hankinsoft/SQLPro/issues/315)
+ **[macOS]** Postgres table designer now supports Table comments. [#313](https://github.com/hankinsoft/SQLPro/issues/313)
+ **[macOS]** CTEs and Aliases are now highlighted in the query editor (there is a limitation on the maximum query length before this gets disabled).
+ **[macOS]** Fix for a crash that could occur with autocomplete [317](https://github.com/hankinsoft/SQLPro/issues/317)

### SQLPro 2019.49
+ **[macOS]** Fixed an issue with expand/collapse database tree sidebar (when search tab was selected) which could mess up the UI.
+ **[macOS]** Fixed a crash that could occur when right clicking on some database tree nodes and choosing 'refresh'.
+ **[macOS]** Fixed a few improvements with state restoration.
+ **[macOS]** Improved performance with the search scope selector.

### SQLPro 2019.48
+ **[macOS]** Fixed an issue where right clicking on the 'messages results' (contains text such as 'query finished successfully') could cause crashes.
+ **[macOS]** Fixed an issue where some MySQL errors would not be displayed to the user.
+ **[macOS]** Fixed a performance issue with the connection dialog on macOS 10.13 and before.
+ **[macOS]** Fixed an issue you could sometimes not insert into a table from result sets. (Inserting from a result set still requires a 'simple query'). [#312](https://github.com/hankinsoft/SQLPro/issues/312)
+ **[macOS]** Added advanced searching. [#180](https://github.com/hankinsoft/SQLPro/issues/180)

### SQLPro 2019.47
+ **[macOS]** The `update available` database tree node, now includes a `Changelog` link. [#266](https://github.com/hankinsoft/SQLPro/issues/266)

### SQLPro 2019.40
+ **[macOS]** You can now right click on a table name in the query editor and perform a few actions such as 'select first 1,000 rows', 'script as create statement', 'script as drop and create statement' and 'script as drop statement'. This also works on aliases.
+ **[macOS]** Fixed an issue where entering/exiting full screen could be slow.
+ **[macOS]** Autocomplete now includes partial matches as well as full matches.
+ **[macOS]** Autocomplete is now context sensitive. For example, if you enter `SELECT * FROM myTable WHERE ` autocomplete will suggest myTable and columns related to myTable.
+ **[macOS]** Boolean fields now appear with color (green for true, red for false - this is a preference which can be disabled).
+ **[macOS]** Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
+ **[macOS]** Autocomplete now includes partial word matches.
+ **[macOS]** CTEs are now included in autocomplete.
+ **[Postgres]** Fixed an issue when connecting to Postgres 12 servers (app would either crash, or list the wrong database).
+ **[Postgres]** Fixed an issue with Postgres foreign keys not always loading properly.
+ **[Postgres]** Scripting a Postgres table now includes the foreign key creation scripts.

+ Fixed an issue with connecting to Postgres 12 servers where the app would either display incorrect database or possibly crash.
+ Fixed an issue with setting values from result sets.
+ Autocomplete is now context sensitive. For example, if you enter `SELECT * FROM myTable WHERE ` autocomplete will suggest myTable and columns related to myTable.
+ Boolean fields now appear with color (green for true, red for false - this is a prefernce which can be disabled).
+ Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
+ CTEs are now included in autocomplete.

+ Fixed an issue where some users were unable to cancel queries.

+ Fixed a crash that could occur when trigger autocomplete if your cursor is past the end of all text in the query editor.

+ Query output now displays NOTICES.

+ Fixed a crash which could occur for some users when pasting queries.

+ Colors for connections has been improved (easier to tell which tab is active).
+ You can now pick custom colors for connections.
+ Fixed an issue with SSL that could cause certificate rejections.
+ You can now customize results grid apperance.

+ Fixed an issue where the app could close for some users when opening preferences.
+ The connections window is now resizable on systems running macOS 10.14 and above.
+ Autocomplete no longer requires the AS keyword to detect table aliases.
+ Fixed a crash that could occur when connecting to sample database.

+ Fixed an issue where the app could close for some users when opening preferences.
+ The connections window is now resizable on systems running macOS 10.14 and above.
+ Autocomplete no longer requires the AS keyword to detect table aliases.

Added a new 'keyboard' preferences panel.
+ Query execute shortcut has been moved to this panel.
+ Comment/uncomment keyboard shortcut has been added.
+ Default separator and qualifier for copying results can now be specified. It defaults to comma and double quote, but you can change it as needed.

Postgres specific:
+ Fixed an issue with Postgres foreign keys designer sometimes not allowing users to add columns for mapping.

+ Fixed an issue where schemas were not specified when using the 'Delete rows' context menu item on results.
+ Schema grouping options for the database tree have changed. Schema grouping now defaults to automatic. If you have more than one schema, they will be grouped. One or less will not be grouped. The can also be toggled via individual connections 'advanced' options.

+ Added support for external tables.
+ Stability improvements (fixed the top crashes).

+ You can now click on foreign key columns to be taken to foreign key table data.
+ You can now use pre-existing license keys in SQLPro for Postgres.

+ Fixed a crash that could occur on macOS High Sierra or earlier.

+ Added a lifetime purchase option.

+ Resolved an incorrect display for certain column types.

+ Fixed an issue where views would not always appear under the appropriate schema.

+ Fixed a crash that could occur when cancelling queries.

+ Support for Mojave and dark mode.
+ Performance improvements when opening large files.

+ Resolved a few performance issues.
+ Made some changes in preparations for an upcoming os.

+ Fixed an issue where connection colours were not saving with the application.
+ Fixed an issue where some users may see tabs as black.

+ Updated postgres client library to the latest.
+ Fixed an issue with purchases + added additional logging.

+ Added a color picker to the connection editor. Picking a color will help identify a connection (such as development connections as red and production connections as green).

SQLPro for Postgres is now free for a single connection.

+ Fixed an issue where databases would not appear in the server/database popup if the connection had a database specified.

+ Fixed some issues with resolving connection ip/port from server name.
+ Fixed a crash that could occur on connection.
+ Closing multiple tabs now prompts with an option to review unsaved changes ignoring any changes.

+ Fixed an issue where indexes may not show up in the database tree (specifically for tables which needed to be escaped).
+ Fixed an issue with crash recovery.
+ Fixed a table designer issue where the schema name was not always being used when altering tables.

+ Improvements to database searching.
+ Resolved an issue which could result in a crash during editing results.

+ Fixed an issue with keyboard navigation.

+ Fixed a 'copy from result set' issue where you may end up with more data than selected.

+ Fixed an issue with the comment/uncomment command not adding a required space.
+ Greatly improved memory + performance when selecting results.
+ Fixed an issue where 'shift left' + 'shift right' (cmd + [, cmd + ]) were not using tab style.
+ Fixed an issue where SSH port was not using the user entered value (always defaulted to 22).

+ Fixed a crash that would happen when modifying inline results.

+ SSH tunnelling was not working in specific conditions. This has been resolved.