Grenoble - November 09th, 2020

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 new release v2.2.0 is a port of the extension for PostgreSQL v12 and v13. It works now on all PostgreSQL version from v9.5 to current. It also fixes automatic creation of the underlying temporary table after a rollback.

For the complete list of changes, please checkout the release note on https://github.com/darold/pgtt/blob/master/ChangeLog

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 gilles@darold.net.

Links

• Download: https://github.com/darold/pgtt/releases/
• Support: use GitHub report tool at https://github.com/darold/pgtt/issues