mkstayalive

/**
 * Returns a Segment's KSUID.
 *
 * Reference implementation: https://github.com/segmentio/ksuid
 * Also read: https://segment.com/blog/a-brief-history-of-the-uuid/
 * Taken suggestions from: https://stackoverflow.com/a/71137273/518493
 */
CREATE EXTENSION pgcrypto;

CREATE OR REPLACE FUNCTION fn_ksuid(prefix text DEFAULT '') RETURNS text AS $$