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']);