Table of Contents
standard public schema
Below are the tables, views and functions for public
_int_contained(integer[], integer[]). Language: C Return Type: boolean
_int_contains(integer[], integer[]). Language: C Return Type: boolean
_int_different(integer[], integer[]). Language: C Return Type: boolean
_int_inter(integer[], integer[]). Language: C Return Type: integer[]
_int_overlap(integer[], integer[]). Language: C Return Type: boolean
_int_same(integer[], integer[]). Language: C Return Type: boolean
_int_union(integer[], integer[]). Language: C Return Type: integer[]
_intbig_in(cstring). Language: C Return Type: intbig_gkey
_intbig_out(public.intbig_gkey). Language: C Return Type: cstring
agg_text(text). Language: INTERNAL Return Type: text
akeys(public.hstore). Language: C Return Type: text[]
approximate_date(text, text). Language: SQL Return Type: text
approximate_high_date(text). Language: SQL Return Type: text
approximate_low_date(text). Language: SQL Return Type: text
armor(bytea). Language: C Return Type: text
armor(bytea, text[], text[]). Language: C Return Type: text
avals(public.hstore). Language: C Return Type: text[]
boolop(integer[], public.query_int). Language: C Return Type: boolean
bqarr_in(cstring). Language: C Return Type: query_int
bqarr_out(public.query_int). Language: C Return Type: cstring
call_number_dewey(text). Language: PLPERLU Return Type: text
call_number_dewey(text, integer). Language: SQL Return Type: text
cleanup_acq_marc(). Language: PLPGSQL Return Type: trigger
content_or_null(text). Language: SQL Return Type: text
crypt(text, text). Language: C Return Type: text
dearmor(text). Language: C Return Type: bytea
decrypt(bytea, bytea, text). Language: C Return Type: bytea
decrypt_iv(bytea, bytea, bytea, text). Language: C Return Type: bytea
defined(public.hstore, text). Language: C Return Type: boolean
delete(public.hstore, public.hstore). Language: C Return Type: hstore
delete(public.hstore, text). Language: C Return Type: hstore
delete(public.hstore, text[]). Language: C Return Type: hstore
digest(bytea, text). Language: C Return Type: bytea
digest(text, text). Language: C Return Type: bytea
each(value public.hstore). Language: C Return Type: SET OF record
encrypt(bytea, bytea, text). Language: C Return Type: bytea
encrypt_iv(bytea, bytea, bytea, text). Language: C Return Type: bytea
entityize(text). Language: PLPERLU Return Type: text
exist(public.hstore, text). Language: C Return Type: boolean
exists_all(public.hstore, text[]). Language: C Return Type: boolean
exists_any(public.hstore, text[]). Language: C Return Type: boolean
extract_acq_marc_field(bigint, text, text). Language: SQL Return Type: text
extract_acq_marc_field_set(bigint, text, text). Language: SQL Return Type: SET OF text
fetchval(public.hstore, text). Language: C Return Type: text
first(anyelement). Language: INTERNAL Return Type: anyelement
first5(text). Language: SQL Return Type: text
first_agg(anyelement, anyelement). Language: SQL Return Type: anyelement
first_word(text). Language: SQL Return Type: text
force_to_isbn13(text). Language: PLPERLU Return Type: text
g_int_compress(internal). Language: C Return Type: internal
g_int_consistent(internal, integer[], integer, oid, internal). Language: C Return Type: boolean
g_int_decompress(internal). Language: C Return Type: internal
g_int_penalty(internal, internal, internal). Language: C Return Type: internal
g_int_picksplit(internal, internal). Language: C Return Type: internal
g_int_same(integer[], integer[], internal). Language: C Return Type: internal
g_int_union(internal, internal). Language: C Return Type: integer[]
g_intbig_compress(internal). Language: C Return Type: internal
g_intbig_consistent(internal, internal, integer, oid, internal). Language: C Return Type: boolean
g_intbig_decompress(internal). Language: C Return Type: internal
g_intbig_penalty(internal, internal, internal). Language: C Return Type: internal
g_intbig_picksplit(internal, internal). Language: C Return Type: internal
g_intbig_same(internal, internal, internal). Language: C Return Type: internal
g_intbig_union(internal, internal). Language: C Return Type: integer[]
gen_random_bytes(integer). Language: C Return Type: bytea
gen_random_uuid(). Language: C Return Type: uuid
gen_salt(text). Language: C Return Type: text
gen_salt(text, integer). Language: C Return Type: text
ghstore_compress(internal). Language: C Return Type: internal
ghstore_consistent(internal, internal, integer, oid, internal). Language: C Return Type: boolean
ghstore_decompress(internal). Language: C Return Type: internal
ghstore_in(cstring). Language: C Return Type: ghstore
ghstore_out(public.ghstore). Language: C Return Type: cstring
ghstore_penalty(internal, internal, internal). Language: C Return Type: internal
ghstore_picksplit(internal, internal). Language: C Return Type: internal
ghstore_same(internal, internal, internal). Language: C Return Type: internal
ghstore_union(internal, internal). Language: C Return Type: internal
gin_consistent_hstore(internal, smallint, internal, integer, internal, internal). Language: C Return Type: boolean
gin_extract_hstore(internal, internal). Language: C Return Type: internal
gin_extract_hstore_query(internal, internal, smallint, internal, internal). Language: C Return Type: internal
ginint4_consistent(internal, smallint, internal, integer, internal, internal, internal, internal). Language: C Return Type: boolean
ginint4_queryextract(internal, internal, smallint, internal, internal, internal, internal). Language: C Return Type: internal
hmac(bytea, bytea, text). Language: C Return Type: bytea
hmac(text, text, text). Language: C Return Type: bytea
hs_concat(public.hstore, public.hstore). Language: C Return Type: hstore
hs_contained(public.hstore, public.hstore). Language: C Return Type: boolean
hs_contains(public.hstore, public.hstore). Language: C Return Type: boolean
hstore(record). Language: C Return Type: hstore
hstore(text, text). Language: C Return Type: hstore
hstore(text[]). Language: C Return Type: hstore
hstore(text[], text[]). Language: C Return Type: hstore
hstore_cmp(public.hstore, public.hstore). Language: C Return Type: integer
hstore_eq(public.hstore, public.hstore). Language: C Return Type: boolean
hstore_ge(public.hstore, public.hstore). Language: C Return Type: boolean
hstore_gt(public.hstore, public.hstore). Language: C Return Type: boolean
hstore_hash(public.hstore). Language: C Return Type: integer
hstore_in(cstring). Language: C Return Type: hstore
hstore_le(public.hstore, public.hstore). Language: C Return Type: boolean
hstore_lt(public.hstore, public.hstore). Language: C Return Type: boolean
hstore_ne(public.hstore, public.hstore). Language: C Return Type: boolean
hstore_out(public.hstore). Language: C Return Type: cstring
hstore_recv(internal). Language: C Return Type: hstore
hstore_send(public.hstore). Language: C Return Type: bytea
hstore_to_array(public.hstore). Language: C Return Type: text[]
hstore_to_json(public.hstore). Language: C Return Type: json
hstore_to_json_loose(public.hstore). Language: C Return Type: json
hstore_to_jsonb(public.hstore). Language: C Return Type: jsonb
hstore_to_jsonb_loose(public.hstore). Language: C Return Type: jsonb
hstore_to_matrix(public.hstore). Language: C Return Type: text[]
hstore_version_diag(public.hstore). Language: C Return Type: integer
icount(integer[]). Language: C Return Type: integer
idx(integer[], integer). Language: C Return Type: integer
ingest_acq_marc(). Language: PLPGSQL Return Type: trigger
intarray_del_elem(integer[], integer). Language: C Return Type: integer[]
intarray_push_array(integer[], integer[]). Language: C Return Type: integer[]
intarray_push_elem(integer[], integer). Language: C Return Type: integer[]
integer_or_null(text). Language: SQL Return Type: text
intset(integer). Language: C Return Type: integer[]
intset_subtract(integer[], integer[]). Language: C Return Type: integer[]
intset_union_elem(integer[], integer). Language: C Return Type: integer[]
isdefined(public.hstore, text). Language: C Return Type: boolean
isexists(public.hstore, text). Language: C Return Type: boolean
last(anyelement). Language: INTERNAL Return Type: anyelement
last_agg(anyelement, anyelement). Language: SQL Return Type: anyelement
left_trunc(text, integer). Language: SQL Return Type: text
lowercase(text). Language: PLPERLU Return Type: text
naco_normalize(text). Language: SQL Return Type: text
naco_normalize(text, text). Language: PLPERLU Return Type: text
naco_normalize_keep_comma(text). Language: SQL Return Type: text
non_filing_normalize(text, "char"). Language: SQL Return Type: text
normalize_space(text). Language: SQL Return Type: text
oils_tsearch2(). Language: PLPGSQL Return Type: trigger
pgp_armor_headers(value text). Language: C Return Type: SET OF record
pgp_key_id(bytea). Language: C Return Type: text
pgp_pub_decrypt(bytea, bytea). Language: C Return Type: text
pgp_pub_decrypt(bytea, bytea, text). Language: C Return Type: text
pgp_pub_decrypt(bytea, bytea, text, text). Language: C Return Type: text
pgp_pub_decrypt_bytea(bytea, bytea). Language: C Return Type: bytea
pgp_pub_decrypt_bytea(bytea, bytea, text). Language: C Return Type: bytea
pgp_pub_decrypt_bytea(bytea, bytea, text, text). Language: C Return Type: bytea
pgp_pub_encrypt(text, bytea). Language: C Return Type: bytea
pgp_pub_encrypt(text, bytea, text). Language: C Return Type: bytea
pgp_pub_encrypt_bytea(bytea, bytea). Language: C Return Type: bytea
pgp_pub_encrypt_bytea(bytea, bytea, text). Language: C Return Type: bytea
pgp_sym_decrypt(bytea, text). Language: C Return Type: text
pgp_sym_decrypt(bytea, text, text). Language: C Return Type: text
pgp_sym_decrypt_bytea(bytea, text). Language: C Return Type: bytea
pgp_sym_decrypt_bytea(bytea, text, text). Language: C Return Type: bytea
pgp_sym_encrypt(text, text). Language: C Return Type: bytea
pgp_sym_encrypt(text, text, text). Language: C Return Type: bytea
pgp_sym_encrypt_bytea(bytea, text). Language: C Return Type: bytea
pgp_sym_encrypt_bytea(bytea, text, text). Language: C Return Type: bytea
populate_record(anyelement, public.hstore). Language: C Return Type: anyelement
querytree(public.query_int). Language: C Return Type: text
rboolop(public.query_int, integer[]). Language: C Return Type: boolean
remove_commas(text). Language: SQL Return Type: text
remove_diacritics(text). Language: PLPERLU Return Type: text
remove_paren_substring(text). Language: SQL Return Type: text
remove_whitespace(text). Language: SQL Return Type: text
right_trunc(text, integer). Language: SQL Return Type: text
search_normalize(text). Language: SQL Return Type: text
search_normalize(text, text). Language: PLPERLU Return Type: text
search_normalize_keep_comma(text). Language: SQL Return Type: text
skeys(public.hstore). Language: C Return Type: SET OF text
slice(public.hstore, text[]). Language: C Return Type: hstore
slice_array(public.hstore, text[]). Language: C Return Type: text[]
sort(integer[]). Language: C Return Type: integer[]
sort(integer[], text). Language: C Return Type: integer[]
sort_asc(integer[]). Language: C Return Type: integer[]
sort_desc(integer[]). Language: C Return Type: integer[]
split_date_range(text). Language: SQL Return Type: text
subarray(integer[], integer). Language: C Return Type: integer[]
subarray(integer[], integer, integer). Language: C Return Type: integer[]
svals(public.hstore). Language: C Return Type: SET OF text
tconvert(text, text). Language: C Return Type: hstore
text_concat(text, text). Language: SQL Return Type: text
translate_isbn1013(text). Language: PLPERLU Return Type: text
unaccent(regdictionary, text). Language: C Return Type: text
unaccent(text). Language: C Return Type: text
unaccent_init(internal). Language: C Return Type: internal
unaccent_lexize(internal, internal, internal, internal). Language: C Return Type: internal
uniq(integer[]). Language: C Return Type: integer[]
uppercase(text). Language: PLPERLU Return Type: text
xml_encode_special_chars(text). Language: C Return Type: text
xml_valid(text). Language: INTERNAL Return Type: boolean
xpath_bool(text, text). Language: C Return Type: boolean
xpath_list(text, text). Language: SQL Return Type: text
xpath_list(text, text, text). Language: C Return Type: text
xpath_nodeset(text, text). Language: SQL Return Type: text
xpath_nodeset(text, text, text). Language: SQL Return Type: text
xpath_nodeset(text, text, text, text). Language: C Return Type: text
xpath_number(text, text). Language: C Return Type: real
xpath_string(text, text). Language: C Return Type: text
xpath_table(text, text, text, text, text). Language: C Return Type: SET OF record
xslt_process(text, text). Language: C Return Type: text
xslt_process(text, text, text). Language: C Return Type: text