How to check for custom exceptions raised via RAISE?

[abhijit-hota]

I've a trigger function something like the following:

CREATE OR REPLACE FUNCTION foo() 
RETURNS TRIGGER AS
$$
BEGIN
    IF (bar = 'baz') THEN
        -- something
    ELSE
        RAISE EXCEPTION 'oops error';
    END IF;
    RETURN NEW;
END;
$$
LANGUAGE plpgsql;

How do I check for that error in Golang code?

[abhijit-hota]

Use *pgconn.PgError:

var pgErr *pgconn.PgError
if errors.As(err, &pgErr) {
    //pgErr has all the fluff
}