contrib/indexscan/sql/create_function.sql (3 lines of code) (raw):
-- select * from readindex('pg_class_oid_index'::regclass) as (ictid tid, hctid tid, aotid text, istatus text, hstatus text, oid oid);
-- We'll be using the function to read indexes on the segments, mark the
-- function as EXECUTE ON ALL SEGMENTS.
CREATE OR REPLACE FUNCTION readindex(oid) RETURNS SETOF record AS
'$libdir/indexscan', 'readindex'
LANGUAGE C STRICT VOLATILE EXECUTE ON ALL SEGMENTS;