Taipei, Taiwan - November 14th, 2024

PostgreSQL Global Temporary Tables - RSL

pgtt_rsl is a PostgreSQL extension to create and manage Oracle or DB2 style Global Temporary Tables. It is based on unlogged tables, Row Security Level and views. A background worker is responsible to periodically remove obsolete rows and tables. This implementation is designed to avoid catalog bloating when creating a lot of temporary tables.

An other difference is that Oracle or DB2 Global Temporary Table can be created in any schema while it is not possible with PostgreSQL where temporary table are stored in the pg_temp namespace. This version of the extension aallow to create the global temporary table in any schema.

pgtt v2.0 has been released, this is a major release that adds the following features.

• Add support to CREATE GLOBAL TEMPORARY TABLE, CREATE GLOBAL TEMPORARY TABLE ... AS SELECT and DROP TABLE.
• Allow to create the global temporary table into any schema.
• Allow sub-transaction generated by SAVEPOINT.

Complete list of changes is available here

Links & Credits

pgtt-rsl 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-rsl/
• Download: https://github.com/darold/pgtt-rsl/releases/
• Support: use GitHub report tool at https://github.com/darold/pgtt-rsl/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 and DB2 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.