Bangkok, Thailand - June 21, 2026
## 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.5 has been released, this is a maintenance release to add support to
PG 19 and add support to CREATE INDEX CONCURRENTLY. and fix issues reported by
users since last release.
- Fix -Wmissing-variable-declarations warnings by making globals static.
- Remove use of the registered relid of the relation. When restoring
pgtt_schema.pg_global_temp_tables from a dump it contains invalid Oid
for the relation. Thanks to sibowu-aws for the report.
Complete list of changes is available
[here](https://github.com/darold/pgtt/blob/v4.5/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.
**Links :**
* Documentation:
[https://github.com/darold/pgtt/](https://github.com/darold/pgtt/)
* Download:
[https://github.com/darold/pgtt/releases/](https://github.com/darold/pgtt/releases/)
* Support: use GitHub report tool at
[https://github.com/darold/pgtt/issues](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](https://hexacluster.ai)
