Antananarivo, Madagascar - June 9th, 2025

PostgreSQL Global Temporary Tables

pgtt is a PostgreSQL extension to create, manage and use DB2 or Oracle-style Global Temporary Tables. Once created the use is just like with the other RDBMS.

pgtt v4.3 has been released, this is a maintenance release to fix issues reported by users since latest release and especially a search_path modification issue.

• Preserve pg_catalog at end of search path if it is the case to allow pg_catalog overloaded function to be executed.
• Preserve $user and other elements in search_path.

Complete list of changes is available here

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.

Links :

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

About pgtt

The objective of this extension it to provide the Global Temporary Table feature waiting for an in core implementation. The main interest of this extension is to mimic the Oracle behavior with GTT when you can not or don't want to rewrite the application code when migrating to PostgreSQL.

This is a project created and maintained by Gilles Darold at HexaCluster Corp.