Introduction

License

Installation

$ cd pg_variables$ make USE_PGXS=1$ sudo make USE_PGXS=1 install$ make USE_PGXS=1 installcheck$ psql DB -c "CREATE EXTENSION pg_variables;"

Module functions

Integer variables

Text variables

Numeric variables

Timestamp variables

Timestamp with timezone variables

Date variables

Jsonb variables

Records

Miscellaneous functions

Examples

SELECT pgv_set_int('vars','int1',101);SELECT pgv_set_int('vars','int2',102);SELECT pgv_get_int('vars','int1'); pgv_get_int-------------101(1 row)SELECT pgv_get_int('vars','int2'); pgv_get_int-------------102(1 row)

CREATETABLEtab (idint, tvarchar);INSERT INTO tabVALUES (0,'str00'), (1,'str11');

SELECT pgv_insert('vars','r1', tab)FROM tab;SELECT pgv_select('vars','r1'); pgv_select------------ (1,str11) (0,str00)(2 rows)SELECT pgv_select('vars','r1',1); pgv_select------------ (1,str11)(1 row)SELECT pgv_select('vars','r1',0); pgv_select------------ (0,str00)(1 row)SELECT pgv_select('vars','r1', ARRAY[1,0]); pgv_select------------ (1,str11) (0,str00)(2 rows)SELECT pgv_delete('vars','r1',1);SELECT pgv_select('vars','r1'); pgv_select------------ (0,str00)(1 row)

SELECT*FROM pgv_list()order by package, name; package | name---------+------ vars    | int1 vars    | int2 vars    | r1(3 rows)

SELECT*FROM pgv_stats()order by package; package | used_memory---------+------------- vars    |16736(1 row)

SELECT pgv_remove('vars','int1');SELECT pgv_remove('vars');

SELECT pgv_free();