Chapter 18. Schema public

Table of Contents

Functions in public

standard public schema

Below are the tables, views and functions for public

Functions in 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