pgsql_tweaks

pig build pkg pgsql_tweaks;		# build deb

pig repo add pgsql -u   # add both repo and update cache

pig install pgsql_tweaks;		# install via package name, for the active PG version

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

CREATE EXTENSION pgsql_tweaks;

SELECT pgsql_tweaks.is_date('2024-01-15');       -- true
SELECT pgsql_tweaks.is_integer('42');             -- true
SELECT pgsql_tweaks.is_numeric('3.14');           -- true
SELECT pgsql_tweaks.is_json('{"a":1}');           -- true
SELECT pgsql_tweaks.is_jsonb('{"a":1}');          -- true
SELECT pgsql_tweaks.is_boolean('true');            -- true
SELECT pgsql_tweaks.is_timestamp('2024-01-15 10:30:00');  -- true
SELECT pgsql_tweaks.is_hex('FF');                 -- true

SELECT pgsql_tweaks.pg_schema_size('public');     -- schema size in bytes

SELECT pgsql_tweaks.to_unix_timestamp(now());
SELECT pgsql_tweaks.hex2bigint('FF');

SELECT pgsql_tweaks.is_empty('');                 -- true
SELECT pgsql_tweaks.array_trim(ARRAY['a','','b']);