![create a unique index postico create a unique index postico](https://www.gangboard.com/wp-content/uploads/2020/01/unique-index.png)
![create a unique index postico create a unique index postico](http://i.stack.imgur.com/iyju8.png)
#Create a unique index postico update
Postico now uses Notification Center to show update notifications.Additional keyboard shortcuts: Shift Left ⌘ #103.You can now change the tab width (default 4 spaces) and use spaces instead of tabs #103.Press Ctrl-H to look up the current word in Dash #176.Added a search field to filter databases.Postico no longer attempts to load columns that you don't have permission to view.Postico now remembers whether you last used the contents or structure view #40.Improved display of floating point numbers #166.The number of selected rows is now displayed in the status bar #170.Postico now adjusts column widths intelligently #87.Added preferences for font size, number of lines per row, alternating row background color #26#38.Fixed a crash when displaying error messages on macOS 10.9 #276.Fixed a crash when Postico opens many connections simultaneously (eg.The bundled version of libpq was updated to version 9.5.4.Postico now remembers the size & position of the favorites window.Added a hidden setting to disable restoring the text in the SQL Query View #256 defaults write at.eggerapps.Postico DontRestoreQueryViewText 1.“Clear Results” command (⌘K) lets you clear the SQL Query View #262.Error messages are no longer duplicated in the SQL Query View #262.Add support for deleting and renaming indices in CockroachDB #251.Fixed an issue where Postico disconnected from the server after an error occurred when using localised error messages #255.Fixed a number of issues where syntax highlighting did not work as expected.Copy INSERT now includes table schema #197.Added “Copy JSON” and “Copy HTML Table” commands #245.It is also faster, more stable, and has improved ranking of search results. The “Open Quickly” now works better across multiple databases.
![create a unique index postico create a unique index postico](https://blog.sqlauthority.com/i/b/duptr2.jpg)
When this happened, Postico just showed the message 'Working.' and did nothing #294 Since libpq 9.5.5 no longer uses the shared SSL Context, this release should also fix a potential deadlock while connecting.Updated bundled libraries: libpq 9.5.5, OpenSSL 1.0.2j, libssh2 1.8.0.Fixed a bug where using the Quick Open command accidentally filtered tables in the side bar.Fixed a crash when adding large files to bytea fields #299.Fixed a bug that caused high CPU usage while Postico is connecting via SSH #123.Added purple color option for favorites.Just execute the following command: defaults write at.eggerapps.Postico CreateFavoritesForURLs 0 Are you annoyed that Postico automatically creates a favorite when you open a postgres:// URL? You can now disable this behavior with a hidden preference.Improved performance when editing large SQL scripts in the query view.The elapsed time for queries is now printed with monospaced digits to avoid jittering.Additionally, Postico now displays a status icon after the query completes so you immediately see if it succeeded. In the query view, Postico now immediately displays error messages even when a query returns rows.
#Create a unique index postico pro
![create a unique index postico create a unique index postico](https://img2018.cnblogs.com/blog/562987/201810/562987-20181027163728600-945394918.png)
Postico now has a really nice GUI for adding indexes. Create Indexes for Tables and Materialized Views.