PostgreSQL Global Temporary Tables extension v2.6 released

Posted on 2021-09-28 by Gilles Darold
Related Open Source

Grenoble - September 28th, 2021

PostgreSQL Global Temporary Tables

pgtt is a PostgreSQL extension to create, manage and use Oracle-style Global Temporary Tables.

The main interest of this extension is to reproduce Oracle behavior with GTT when you can not or don't want to rewrite the application code when migrating to PostgreSQL. In all other case best is to rewrite the code to use standard PostgreSQL temporary tables.

This is a maintenance release to add support for upcomming PostgreSQL 14 and fixed some issues reported in the past three months.

  • Add support to PostgreSQL 14. Thanks to Devrim Gunduz for the report and MigOps Inc for the patch.
  • Remove support to PG 9.5 which obviously was not working. Minimal PostgreSQL version for this extension is 9.6.
  • Fix documentation menu.
  • Fix creation of GTT when there is a CHECK constraint with string constant.

For the complete list of changes, please checkout the release note on

Links & Credits

pgtt is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to