login_hook

pig build pkg login_hook;		# build rpm/deb

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

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

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

CREATE EXTENSION login_hook;

CREATE EXTENSION login_hook;

session_preload_libraries = 'login_hook'

CREATE OR REPLACE FUNCTION login_hook.login() RETURNS VOID LANGUAGE PLPGSQL AS $$
BEGIN
    IF NOT login_hook.is_executing_login_hook() THEN
        RAISE EXCEPTION 'Should only be invoked by login_hook';
    END IF;

    -- Your login logic here:
    RAISE NOTICE 'Hello %', current_user;

EXCEPTION
    WHEN OTHERS THEN
        RAISE LOG 'Error in login_hook.login(): %', SQLERRM;
END
$$;
GRANT EXECUTE ON FUNCTION login_hook.login() TO PUBLIC;