1/* contrib/pageinspect/pageinspect--unpackaged--1.0.sql */ 2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION 4\echo Use "CREATE EXTENSION pageinspect FROM unpackaged" to load this file. \quit 5 6DROP FUNCTION heap_page_items(bytea); 7CREATE FUNCTION heap_page_items(IN page bytea, 8 OUT lp smallint, 9 OUT lp_off smallint, 10 OUT lp_flags smallint, 11 OUT lp_len smallint, 12 OUT t_xmin xid, 13 OUT t_xmax xid, 14 OUT t_field3 int4, 15 OUT t_ctid tid, 16 OUT t_infomask2 integer, 17 OUT t_infomask integer, 18 OUT t_hoff smallint, 19 OUT t_bits text, 20 OUT t_oid oid) 21RETURNS SETOF record 22AS 'MODULE_PATHNAME', 'heap_page_items' 23LANGUAGE C STRICT; 24 25ALTER EXTENSION pageinspect ADD function get_raw_page(text,integer); 26ALTER EXTENSION pageinspect ADD function get_raw_page(text,text,integer); 27ALTER EXTENSION pageinspect ADD function page_header(bytea); 28ALTER EXTENSION pageinspect ADD function bt_metap(text); 29ALTER EXTENSION pageinspect ADD function bt_page_stats(text,integer); 30ALTER EXTENSION pageinspect ADD function bt_page_items(text,integer); 31ALTER EXTENSION pageinspect ADD function fsm_page_contents(bytea); 32