Postgresql 14 5

Author: u | 2025-04-25

PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services

PostgreSQL 14 Support in dotConnect for PostgreSQL

Download PostgreSQL 10.18 Date released: 13 Aug 2021 (4 years ago) Download PostgreSQL 10.17 Date released: 14 May 2021 (4 years ago) Download PostgreSQL 10.16 Date released: 12 Feb 2021 (4 years ago) Download PostgreSQL 10.15 Date released: 13 Nov 2020 (4 years ago) Download PostgreSQL 10.14 Date released: 25 Aug 2020 (5 years ago) Download PostgreSQL 10.13 Date released: 22 May 2020 (5 years ago) Download PostgreSQL 10.9 (32-bit) Date released: 31 Jul 2019 (6 years ago) Download PostgreSQL 10.9 (64-bit) Date released: 31 Jul 2019 (6 years ago) Download PostgreSQL 10.7 (32-bit) Date released: 15 Feb 2019 (6 years ago) Download PostgreSQL 10.7 (64-bit) Date released: 15 Feb 2019 (6 years ago) Download PostgreSQL 10.5.1 (32-bit) Date released: 09 Aug 2018 (7 years ago) Download PostgreSQL 10.5.1 (64-bit) Date released: 09 Aug 2018 (7 years ago) Download PostgreSQL 10.4.1 (32-bit) Date released: 11 May 2018 (7 years ago) Download PostgreSQL 10.4.1 (64-bit) Date released: 11 May 2018 (7 years ago) Download PostgreSQL 10.3.2 (32-bit) Date released: 21 Apr 2018 (7 years ago) Download PostgreSQL 10.3.2 (64-bit) Date released: 21 Apr 2018 (7 years ago) Download PostgreSQL 10.3 (32-bit) Date released: 01 Mar 2018 (7 years ago) Download PostgreSQL 10.3 (64-bit) Date released: 01 Mar 2018 (7 years ago) Download PostgreSQL 10.2 (32-bit) Date released: 08 Feb 2018 (7 years ago) Download PostgreSQL 10.2 (64-bit) Date released: 08 Feb 2018 (7 years ago)

PostgreSQL 14 - pgPedia - a PostgreSQL Encyclopedia

Visit our Customer Center. Oct 17 2023 Navicat for PostgreSQL (macOS) version 16.3.0 Bug-fixes:Crashed when transferring large tables using SSH connection.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 20 2023 Navicat for PostgreSQL (macOS) version 16.2.9 Bug-fixes:Crashed on macOS 14.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 28 2023 Navicat for PostgreSQL (macOS) version 16.2.7 Bug-fixes:Beautify SQL incorrectly added spaces between the function name and parentheses.Dump SQL File did not correctly generate DEFAULT PARTITION.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 8 2023 Navicat for PostgreSQL (macOS) version 16.2.6 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jul 14 2023 Navicat for PostgreSQL (macOS) version 16.2.5 Main New Features:Show fields, indexes and more under tables in Navigation Pane.Minor bug fixes and improvements.Navicat for Redis is released.To upgrade, please visit our Customer Center. Apr 26 2023 Navicat for PostgreSQL (macOS) version 16.1.10 Bug-fixes:High CPU usage when using SSH connection.Unable to save the schedule changes.TAB key did not work when adding field.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Apr 17 2023 Navicat for PostgreSQL (macOS) version 16.1.9 Bug-fixes:Crashed when opening Preferences in some cases.Crashed when importing database to model in some cases.Crashed when saving table after changing field comment.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 1 2023 Navicat for PostgreSQL (macOS) version 16.1.7 Bug-fixes:Memory utilization issue.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Feb 15 2023 Navicat for PostgreSQL (macOS) version 16.1.6 Bug-fixes:Unable to backup if database folder did not exist.Unable to load cloud connection info when opening data transfer profile.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 12 2022 Navicat for PostgreSQL (macOS) version 16.1.5 Bug-fixes:Default value did not show when adding new records.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 5 2022 Navicat for PostgreSQL (macOS) version 15.0.36 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 21 2022 Navicat for PostgreSQL (macOS) version 16.1.4 Main New Features:Support Trend Line for several chart types.Support adding On-Prem Server with URI.Allow skip preview of changes in data sync.Enhanced responsiveness and performance.Improved UI/UX.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jun 14 2022 Navicat for PostgreSQL (macOS) version 16.0.14 Main New Features:New Data Generation ToolEnhanced Charts FeatureSupport of Navicat On-Prem Server Additional Features:Connection ProfilesField Information Pane PostgreSQL Extensions ManagementQuery Execution SummaryNavicat On-Prem Server is releasedMany other new features and improvementsTo upgrade, please visit our Customer Center. Mar 21 2022 Navicat for PostgreSQL (macOS) version 15.0.35 Bug-fixes:Crashed when hovering over tabs.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Feb 8

PostgreSQL: Documentation: 14: 1. What Is PostgreSQL?

Jun 16 2021 Navicat for PostgreSQL (Linux) version 15.0.27 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. May 26 2021 Navicat for PostgreSQL (Linux) version 15.0.26 Bug-fixes:Crashed when the query returned a large result set.Not all matching data was highlighted when searching the query results.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Apr 14 2021 Navicat for PostgreSQL (Linux) version 15.0.25 Bug-fixes:Crashed when working with PostgreSQL.Crashed after refreshing the table.Unable to set privileges for PostgreSQL functions.Crashed when importing PostgreSQL database to the model.Hanged when dragging a table from the main window to the model window.Incorrect default field size issue in Table Designer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 10 2021 Navicat for PostgreSQL (Linux) version 15.0.24 Bug-fixes:CTRL+R shortcut did not apply the filter.Unable to view TEXT data in Data Synchronization.Unable to show the input text in Table Viewer when using Dark Mode.Missing the primary key warning in Table Viewer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 13 2021 Navicat for PostgreSQL (Linux) version 15.0.23 Bug-fixes:Unable to export the fractional part when the decimal separator was comma.Unable to select privileges in the "Add Privilege" window by using the Space key.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 25 2020 Navicat for PostgreSQL (Linux) version 15.0.22 Bug-fixes:Crashed when restoring the backup file to another database.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 27 2020 Navicat for PostgreSQL (Linux) version 15.0.21 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 16 2020 Navicat for PostgreSQL (Linux) version 15.0.20 Bug-fixes:Crashed when using Charts in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 5 2020 Navicat for PostgreSQL (Linux) version 15.0.19 Bug-fixes:The number of processes was missing in the Server Monitor window.Unable to delete multiple fields in Table Designer.The tab of Table Designer did not mark with * after deleting a field.Some buttons were disabled at all times in New Query.Unable to copy and paste multiple rows data to another table.Right-clicking a row header in data grid highlighted the corresponding column.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jun 24 2020 Navicat for PostgreSQL (Linux) version 15.0.18 Bug-fixes:Crashed when editing functions.No server, database and schema were selected when opening query.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jun 17 2020 Navicat for PostgreSQL (Linux) version 15.0.17 Bug-fixes:An empty diagram was created when reversing a database to a model.Unable to change font for Editor and Records.Query returned different results for an empty row.DROP DEFAULT clause was incorrectly added to the statement when opening PostgreSQL table designer.Unable to copy the. PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services

PostgreSQL : Documentation: 14: PostgreSQL 14.15 Documentation

Download PostgreSQL 17.4 Date released: 21 Feb 2025 (3 weeks ago) Download PostgreSQL 17.3 Date released: 14 Feb 2025 (4 weeks ago) Download PostgreSQL 17.2 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 17.1 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 17.0 Date released: 26 Sep 2024 (6 months ago) Download PostgreSQL 16.8 Date released: 21 Feb 2025 (3 weeks ago) Download PostgreSQL 16.6 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 16.5 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 16.4 Date released: 09 Aug 2024 (7 months ago) Download PostgreSQL 16.3 Date released: 10 May 2024 (10 months ago) Download PostgreSQL 16.1 Date released: 10 Nov 2023 (one year ago) Download PostgreSQL 15.12 Date released: 22 Feb 2025 (3 weeks ago) Download PostgreSQL 15.10 Date released: 22 Nov 2024 (4 months ago) Download PostgreSQL 15.9 Date released: 14 Nov 2024 (4 months ago) Download PostgreSQL 15.8 Date released: 09 Aug 2024 (7 months ago) Download PostgreSQL 15.5 Date released: 10 Nov 2023 (one year ago) Download PostgreSQL 15.4 Date released: 11 Aug 2023 (one year ago) Download PostgreSQL 15.3 Date released: 12 May 2023 (one year ago) Download PostgreSQL 15.2 Date released: 10 Feb 2023 (2 years ago) Download PostgreSQL 15.1 Date released: 10 Nov 2022 (2 years ago)

PostgreSQL: How to download install PostgreSQL 14 on

Not correctly generate DEFAULT PARTITION.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 14 2023 Navicat for PostgreSQL (Windows) version 16.2.7 Bug-fixes:Incorrectly triggering code completion when pressing ENTER in Query Editor.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 7 2023 Navicat for PostgreSQL (Windows) version 16.2.6 Bug-fixes:Unable to close tabs in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jul 14 2023 Navicat for PostgreSQL (Windows) version 16.2.5 Main New Features:Show fields, indexes and more under tables in Navigation Pane.Minor bug fixes and improvements.Navicat for Redis is released.To upgrade, please visit our Customer Center. Apr 26 2023 Navicat for PostgreSQL (Windows) version 16.1.15 Bug-fixes:High CPU usage when using SSH connection."permission denied for view geometry_columns" error occurred when opening PostgreSQL table.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Apr 17 2023 Navicat for PostgreSQL (Windows) version 16.1.12 Bug-fixes:Query Builder window was larger than the screen in some cases.Unable to display full server output in Query's Message tab.Modifying PostgreSQL table with a geometry field and no primary key did not take effect.Unable to display the data differences of TEXT fields in Data Synchronization.The second field was selected when adding a sort condition in Table Viewer.Crashed when stopping Data Transfer process.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 13 2023 Navicat for PostgreSQL (Windows) version 16.1.11 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 1 2023 Navicat for PostgreSQL (Windows) version 16.1.9 Bug-fixes:Memory utilization issue.Modification did not take effect on tables with geometry fields and no primary key.Table Viewer did not show the SQL if errors occurred.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Feb 8 2023 Navicat for PostgreSQL (Windows) version 16.1.8 Bug-fixes:Unable to save changes after deleting a cell value in Table Viewer.Access violation error occurred when opening a model.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jan 31 2023 Navicat for PostgreSQL (Windows) version 16.1.7 Improvements:Support the PARALLEL option for PostgreSQL functions.Bug-fixes:Cannot display column comment when mouse over in dark mode.Missing $$ quotes in PostgreSQL function definition.Data Synchronization did not work in Automation."Failed to send mail. Stream error." occurred when sending email.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 12 2022 Navicat for PostgreSQL (Windows) version 16.1.6 Bug-fixes:"Cannot open source table" error occurred when using Condition Query in Import Wizard.Exporting to Excel file was slow.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 5 2022 Navicat for PostgreSQL (Windows) version 15.0.29 Bug-fixes:Failed to transfer large tables.Crashed when batch querying tables with FK dependency.Unknown Internal Error occurred when exporting large amount of data.Minor bug fixes and

PostgreSQL 14 x86_32 ? : r/PostgreSQL - Reddit

Connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.Improvements:Support PostgreSQL 9.3 Materialized View.Support adding shapes in Model.To upgrade, please visit our Customer Center. Mar 13 2025 Navicat for PostgreSQL (Linux) version 17.2.1 Main New Features:Support AI AssistantData Modeling supports Data Vault and Dimensional modeling methodsBI data source supports data profilingFilter & Sort pane in Table Viewer supports Text modeSome minor bug fixes and usability improvementsTo upgrade, please visit our Customer Center. Feb 6 2025 Navicat for PostgreSQL (Linux) version 17.1.8 Bug-fixes:Error occurred when saving changes in PostgreSQL Function.Unable to access PostgreSQL Sequence.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 16 2024 Navicat for PostgreSQL (Linux) version 17.1.7 Bug-fixes:Model workspaces created by Windows version cannot be saved using Linux version.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 21 2024 Navicat for PostgreSQL (Linux) version 17.1.6 Bug-fixes:Unable to scroll horizontally using mouse in data grid.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 14 2024 Navicat for PostgreSQL (Linux) version 17.1.5 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 7 2024 Navicat for PostgreSQL (Linux) version 17.1.4 Bug-fixes:Crashed when closing tabs in some cases.Incorrect CREATE INDEX statement was displayed in the DDL pane.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 8 2024 Navicat for PostgreSQL (Linux) version 17.1.3 Bug-fixes:Unable to open database connection after VPN disconnected/reconnected.Crashed when starting Navicat in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 10 2024 Navicat for PostgreSQL (Linux) version 17.1.1 Main New Features:All-New Model WorkspaceData ProfilingData DictionaryQuery Pinned ResultVisual Query ExplainTable ProfileNavicat URIManage ConnectionEnhanced BI FeatureFocus ModeSupport Alibaba Cloud PolarDB for PostgreSQLLinux ARM VersionMany other new features and improvementsTo upgrade, please visit our Customer Center. Mar 5 2024 Navicat for PostgreSQL (Linux) version 16.3.4 Bug-fixes:Primary key index incorrectly displayed when data type was citext.Some labels disappeared after adding the chart to the dashboard.Unable to display proportion percentages in the chart axis.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 27 2023 Navicat for PostgreSQL (Linux) version 16.3.3 Bug-fixes:The SQL scripts generated for PostgreSQL models were incorrect in some cases.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 23 2023 Navicat for PostgreSQL (Linux) version 16.3.2 Improvements:Support enabling or disabling "Detect Data Types" in Import Wizard.Bug-fixes:Primary keys were not displayed for PostgreSQL partitioned tables.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 2 2023 Navicat for PostgreSQL (Linux) version 16.3.1 Bug-fixes:PostgreSQL Table Designer did not recognize primary keys.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Oct 17 2023 Navicat for PostgreSQL (Linux)

PostgreSQL: Documentation: 14: PostgreSQL Client Applications

Version 16.3.0 Bug-fixes:Crashed when using Structure Synchronization.Crashed when changing data display in Charts.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 13 2023 Navicat for PostgreSQL (Linux) version 16.2.7 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 5 2023 Navicat for PostgreSQL (Linux) version 16.2.6 Bug-fixes:Beautify SQL incorrectly added spaces between the function name and parentheses.Unable to set table inheritance for PostgreSQL in Model.Dump SQL File did not correctly generate DEFAULT PARTITION.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 10 2023 Navicat for PostgreSQL (Linux) version 16.2.5 Bug-fixes:Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jul 14 2023 Navicat for PostgreSQL (Linux) version 16.2.4 Main New Features:Show fields, indexes and more under tables in Navigation Pane.Minor bug fixes and improvements.Navicat for Redis is released.To upgrade, please visit our Customer Center. Apr 26 2023 Navicat for PostgreSQL (Linux) version 16.1.8 Bug-fixes:High CPU usage when using SSH connection.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Mar 1 2023 Navicat for PostgreSQL (Linux) version 16.1.7 Bug-fixes:Memory utilization issue.Table Viewer did not show the SQL if errors occurred.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Feb 8 2023 Navicat for PostgreSQL (Linux) version 16.1.6 Bug-fixes:Filter value was not highlighted in the pop up window.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Dec 12 2022 Navicat for PostgreSQL (Linux) version 16.1.5 Bug-fixes:Unable to copy field names in Table Designer.Unable to open Comment window in Table Designer.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Nov 21 2022 Navicat for PostgreSQL (Linux) version 16.1.4 Main New Features:Support Trend Line for several chart types.Support adding On-Prem Server with URI.Allow skip preview of changes in data sync.Enhanced responsiveness and performance.Improved UI/UX.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Jun 14 2022 Navicat for PostgreSQL (Linux) version 16.0.12 Main New Features:New Data Generation ToolEnhanced Charts FeatureSupport of Navicat On-Prem Server Additional Features:Connection ProfilesField Information Pane PostgreSQL Extensions ManagementQuery Execution SummaryNavicat On-Prem Server is releasedMany other new features and improvementsTo upgrade, please visit our Customer Center. Oct 20 2021 Navicat for PostgreSQL (Linux) version 15.0.30 Bug-fixes:Unable to launch Navicat after upgrading the system to use GLib-2.70.0 .Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Sep 7 2021 Navicat for PostgreSQL (Linux) version 15.0.29 Bug-fixes:Crashed when viewing or adding emoji data.Minor bug fixes and improvements.To upgrade, please visit our Customer Center. Aug 16 2021 Navicat for PostgreSQL (Linux) version 15.0.28 Bug-fixes:The Stop button did not work when processing deletion in the table viewer.Error occurred when editing data in query results.Minor bug fixes and improvements.To upgrade, please visit our Customer Center.. PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services

PostgreSQL : Documentation: 14: PostgreSQL 14.12 Documentation

Convert any data source to convert any data source5 MySQL Migration Toolkit is a software pack to convert any data source to MySQL and vice versa. It includes the following utilities: (1) Access-to-MySQL - migrates MS Access database to MySQL server; (2) DB2-to-MySQL - migrates IBM DB2 databases to MySQL server;(3) DBF-to-MySQL - moves DBase (dbf) databases to MySQL server;(4) Excel-to-MySQL - converts MS Excel spreadsheet into MySQL database; (5) MSSQL-to-MySQL - migrates MS SQL database to MySQL server; (6) MySQL-to-Access - converts MySQL database into MS Access format; (7) MySQL-to-DB2 - migrates MySQL databases to IBM DB2 server;(8) MySQL-to-DBF - converts MySQL databases into DBase (dbf) format;(9) MySQL-to-Excel - converts MySQL database into MS Excel spreadsheet; (10) MySQL-to-MSSQL - migrates MySQL database to MS SQL server; (11) MySQL-to-Oracle - migrates MySQL database to Oracle server; (12) MySQL-to-PostgreSQL - migrates MySQL database to PostgreSQL server; (13) Oracle-to-MySQL - migrates Oracle database to MySQL server;(14) PostgreSQL-to-MySQL - migrates PostgreSQL database to MySQL server.

PostgreSQL : Documentation: 14: 1. What Is PostgreSQL?

As previously mentioned here on the blog, PostgreSQL 14 was just released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability.I recently did a deep-dive into using JSON from within PostgreSQL in a two blog post series titled Storing and using JSON within PostgreSQL, While all the information from those two blogs still is relevant with the release of PostgreSQL 14 (PG14), we need to provide a quick update to show off some improvements.Keeping this brief: Prior to PG14, pulling fields out of JSON looked something like the following:movie_json_test=# select jsonb_column->>'title' as title, jsonb_column->>'imdb_rating' as rating, jsonb_column->>'imdb_id' as imdb_id from movies_jsonb where (jsonb_column->>'title')::varchar = 'Avengers: Endgame (2019)'; title | rating | imdb_id --------------------------+--------+----------- Avengers: Endgame (2019) | | tt4154796(1 row)While this worked, it is not terribly intuitive for developers who may be used to interacting with JSON in code. Starting in versions beyond 14 you can use a much more natural and user-friendly syntax to access data.movie_json_test=# select jsonb_column['title'] as title, jsonb_column['imdb_rating'] as rating, jsonb_column['imdb_id'] as imdb_id from movies_jsonb where jsonb_column['title'] = '"Avengers: Endgame (2019)"'; title | rating | imdb_id ----------------------------+--------+------------- "Avengers: Endgame (2019)" | null | "tt4154796"(1 row)Not only can you access top-level attributes, but you can also access nested arrays and lists as well:movie_json_test=# select jsonb_column['title'] as title, jsonb_column['imdb_rating'] as rating, jsonb_column['imdb_id'] as imdb_id, jsonb_column['cast'][0] from movies_jsonb where jsonb_column['title'] = '"Avengers: Endgame (2019)"'; title | rating | imdb_id | jsonb_column ----------------------------+--------+-------------+----------------------------------------------------------------------------------------------------- "Avengers: Endgame (2019)" | null | "tt4154796" | {"id": "nm0000375", "name": "Robert Downey Jr.", "character": "Tony Stark / Iron Man"}(1 row)Overall this syntax still will make use of all the same indexes, JSON functions, etc., that were previously available. While this is a relatively minor change, it actually should make things much more natural for developers and hopefully drive more adoption and usageRead Our New White Paper:Why Customers Choose Percona for PostgreSQL. PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services PostgreSQL 16 PostgreSQL 15 PostgreSQL 14 PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.6 PostgreSQL 9.5 PostgreSQL 9.4 Go to PostgreSQL 14 Services

PostgreSQL: Documentation: 14: 19.6. Upgrading a PostgreSQL

The PostgreSQL database versions 14 and 15. While version 15 is the default, version 14 is still provided through the Legacy module for upgrades from earlier versions of SUSE Linux Enterprise Server. Because of the required migration work of the database, there is no automatic upgrade process. As such, the switch from one version to another needs to be performed manually. The migration process is conducted by the pg_upgrade command, which is an alternative method of the classic dump and reload. In comparison with the “dump and reload” method, pg_upgrade makes the migration less time-consuming. The program files for each PostgreSQL version are stored in different, version-dependent directories. For example, in /usr/lib/postgresql96/ for version 9.6, in /usr/lib/postgresql10/ for version 10, and in /usr/lib/postgres13/ for version 13. Note that the versioning policy of PostgreSQL has changed between the major versions 9.6 and 10. For details, see Important: Upgrading from SLE 11 When upgrading from SLE 11, postgresql94 will be uninstalled and cannot be used for the database migration to a higher PostgreSQL version. Therefore, in this case, make sure to migrate the PostgreSQL database before you upgrade your system. The procedure below describes the database migration from version 12 to 13. When using a different version as start or target, replace the version numbers accordingly. To perform the database migration, do the following: Make sure the following preconditions are fulfilled: If not already done, upgrade any package of the old PostgreSQL version to the latest release through a maintenance update. Create a backup of your existing database. Install the packages for the new PostgreSQL major version. For SLE 15 SP5, this means installing postgresql13-server and all the packages it depends on. Install the package postgresql13-contrib, which contains the command pg_upgrade. Make sure you have enough free space in your PostgreSQL data