hstore_pllua

pllua : Hstore transform for Lua

Overview

ID	Extension	Package	Version	Category	License	Language
3021	hstore_pllua	pllua	`2.0.12`	LANG	MIT	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
Requires	hstore pllua
See Also	hstore_plperl hstore_plperlu hstore_plpython3u plpgsql
Siblings	pllua plluau hstore_plluau

missing pg12-15 on el.aarch64

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PGDG	`2.0.12`	18 17 16 15 14	`pllua`	`hstore`, `pllua`
DEB	PGDG	`2.0.12`	18 17 16 15 14	`postgresql-$v-pllua`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	MISS	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.11	PGDG 2.0.11
el8.aarch64	MISS	PGDG 2.0.12	PGDG 2.0.12	MISS	MISS
el9.x86_64	MISS	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.11	PGDG 2.0.11
el9.aarch64	MISS	PGDG 2.0.12	PGDG 2.0.12	MISS	MISS
el10.x86_64	MISS	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
el10.aarch64	MISS	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
d12.x86_64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
d12.aarch64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
d13.x86_64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
d13.aarch64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
u22.x86_64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
u22.aarch64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
u24.x86_64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12
u24.aarch64	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12	PGDG 2.0.12

Source

Repository

github.com/pllua/pllua

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pllua;		# install via package name, for the active PG version
pig install hstore_pllua;		# install by extension name, for the current active PG version

pig install hstore_pllua -v 18;   # install for PG 18
pig install hstore_pllua -v 17;   # install for PG 17
pig install hstore_pllua -v 16;   # install for PG 16
pig install hstore_pllua -v 15;   # install for PG 15
pig install hstore_pllua -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION hstore_pllua CASCADE; -- requires hstore, pllua

Usage

hstore_pllua: hstore transform for PL/Lua

The hstore_pllua extension provides a transform that allows hstore values to be passed directly to and from PL/Lua functions as native Lua tables, instead of opaque datum objects.

CREATE EXTENSION hstore;
CREATE EXTENSION pllua;
CREATE EXTENSION hstore_pllua;

Using hstore in PL/Lua

With the transform installed, hstore arguments are automatically converted to Lua tables, and Lua tables can be returned as hstore values:

CREATE FUNCTION process_hstore(h hstore) RETURNS hstore LANGUAGE pllua AS $$
  -- h is a Lua table with string keys and string values
  h["new_key"] = "new_value"
  h["modified"] = "true"
  return h
$$;

SELECT process_hstore('name => "Alice", age => "30"'::hstore);

Iterate Over hstore Keys

CREATE FUNCTION hstore_keys(h hstore) RETURNS SETOF text LANGUAGE pllua AS $$
  for k, v in pairs(h) do
    coroutine.yield(k)
  end
$$;

Without this transform, hstore values would need to be manually converted using the hstore type functions.

Last updated on 2026-03-12

pllua plluau