Home

This is a PostgreSQL server-side extension that provides 3 methods for setting, fetching and removing server-side variables. My primary goals for this extension were -

1. Provide a way to save “user” variable at the beginning of HTTP session so my triggers could call “pguser_getvar(‘user’)” and use username for logging.
2. Make a quick dip into the world of PostgreSQL server-side C extensions.
3. This extension uses pgsql’s “dynahash” API, and can be used as an example of how one can create keys/values with dynamic sizes using dynahash.