Evergreen
HomePrev Chapter 26. Database Schema Next

Schema public

standard public schema

Table: staging_items

Columns: 

field name : datatype -- parameters, contraints and notes
l_callnum : text --
hseq : integer --
egid : integer --
createdate : date --
l_location : text --
l_barcode : text --
l_circ_modifier : text --
l_owning_lib : text --

_get_parser_from_curcfg()

Function Properties
Language: SQL
Return Type: text

agg_text(text)

Function Properties
Language: INTERNAL
Return Type: text

agg_tsvector(tsvector)

Function Properties
Language: INTERNAL
Return Type: tsvector

call_number_dewey(text)

Function Properties
Language: PLPERLU
Return Type: text

call_number_dewey(text, integer)

Function Properties
Language: SQL
Return Type: text

cleanup_acq_marc()

Function Properties
Language: PLPGSQL
Return Type: trigger

concat(tsvector, tsvector)

Function Properties
Language: INTERNAL
Return Type: tsvector

connectby(text, text, text, text, integer)

Function Properties
Language: C
Return Type: SET OF record

connectby(text, text, text, text, integer, text)

Function Properties
Language: C
Return Type: SET OF record

connectby(text, text, text, text, text, integer)

Function Properties
Language: C
Return Type: SET OF record

connectby(text, text, text, text, text, integer, text)

Function Properties
Language: C
Return Type: SET OF record

crosstab(text)

Function Properties
Language: C
Return Type: SET OF record

crosstab(text, integer)

Function Properties
Language: C
Return Type: SET OF record

crosstab(text, text)

Function Properties
Language: C
Return Type: SET OF record

crosstab2(text)

Function Properties
Language: C
Return Type: SET OF tablefunc_crosstab_2

crosstab3(text)

Function Properties
Language: C
Return Type: SET OF tablefunc_crosstab_3

crosstab4(text)

Function Properties
Language: C
Return Type: SET OF tablefunc_crosstab_4

dex_init(internal)

Function Properties
Language: C
Return Type: internal

dex_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

entityize(text)

Function Properties
Language: PLPERLU
Return Type: text

explode_array(anyarray)

Function Properties
Language: SQL
Return Type: SET OF anyelement

extract_acq_marc_field(bigint, text, text)

Function Properties
Language: SQL
Return Type: text

extract_marc_field(text, bigint, text)

Function Properties
Language: SQL
Return Type: text

extract_marc_field(text, bigint, text, text)

Function Properties
Language: PLPGSQL
Return Type: text

facet_force_nfc()

Function Properties
Language: PLPGSQL
Return Type: trigger

first(anyelement)

Function Properties
Language: INTERNAL
Return Type: anyelement

first5(text)

Function Properties
Language: SQL
Return Type: text

first_agg(anyelement, anyelement)

Function Properties
Language: SQL
Return Type: anyelement

first_word(text)

Function Properties
Language: SQL
Return Type: text

force_unicode_normal_form(form text, string text)

Function Properties
Language: PLPERLU
Return Type: text

get_covers(tsvector, tsquery)

Function Properties
Language: C
Return Type: text

headline(oid, text, tsquery)

Function Properties
Language: INTERNAL
Return Type: text

headline(oid, text, tsquery, text)

Function Properties
Language: INTERNAL
Return Type: text

headline(text, text, tsquery)

Function Properties
Language: C
Return Type: text

headline(text, text, tsquery, text)

Function Properties
Language: C
Return Type: text

headline(text, tsquery)

Function Properties
Language: INTERNAL
Return Type: text

headline(text, tsquery, text)

Function Properties
Language: INTERNAL
Return Type: text

ingest_acq_marc()

Function Properties
Language: PLPGSQL
Return Type: trigger

is_json(text)

Function Properties
Language: PLPERLU
Return Type: boolean

last(anyelement)

Function Properties
Language: INTERNAL
Return Type: anyelement

last_agg(anyelement, anyelement)

Function Properties
Language: SQL
Return Type: anyelement

left_trunc(text, integer)

Function Properties
Language: SQL
Return Type: text

length(tsvector)

Function Properties
Language: INTERNAL
Return Type: integer

lexize(oid, text)

Function Properties
Language: INTERNAL
Return Type: text[]

lexize(text)

Function Properties
Language: C
Return Type: text[]

lexize(text, text)

Function Properties
Language: C
Return Type: text[]

lowercase(text)

Function Properties
Language: PLPERLU
Return Type: text

maintain_901()

Function Properties
Language: PLPGSQL
Return Type: trigger

maintain_control_numbers()

Function Properties
Language: PLPERLU
Return Type: trigger

naco_normalize(text)

Function Properties
Language: SQL
Return Type: text

naco_normalize(text, text)

Function Properties
Language: PLPERLU
Return Type: text

naco_normalize_keep_comma(text)

Function Properties
Language: SQL
Return Type: text

non_filing_normalize(text, "char")

Function Properties
Language: SQL
Return Type: text

normal_rand(integer, double precision, double precision)

Function Properties
Language: C
Return Type: SET OF double precision

normalize_space(text)

Function Properties
Language: SQL
Return Type: text

numnode(tsquery)

Function Properties
Language: INTERNAL
Return Type: integer

oils_i18n_code_tracking()

Function Properties
Language: PLPGSQL
Return Type: trigger

oils_i18n_gettext(integer, text, text, text)

Function Properties
Language: SQL
Return Type: text

oils_i18n_gettext(text, text, text, text)

Function Properties
Language: SQL
Return Type: text

oils_i18n_id_tracking()

Function Properties
Language: PLPGSQL
Return Type: trigger

oils_i18n_update_apply(hint text, new_ident text, old_ident text)

Function Properties
Language: PLPGSQL
Return Type: void

oils_i18n_xlate(raw_locale text, keyvalue text, identcol text, keycol text, keyclass text, keytable text)

Function Properties
Language: PLPGSQL
Return Type: text

oils_json_to_text(text)

Function Properties
Language: PLPERLU
Return Type: text

oils_text_as_bytea(text)

Function Properties
Language: SQL
Return Type: bytea

oils_tsearch2()

Function Properties
Language: PLPGSQL
Return Type: trigger

oils_xpath(text, text)

Function Properties
Language: SQL
Return Type: text[]

oils_xpath(text, text, anyarray)

Function Properties
Language: SQL
Return Type: text[]

oils_xpath_string(text, text)

Function Properties
Language: SQL
Return Type: text

oils_xpath_string(text, text, anyarray)

Function Properties
Language: SQL
Return Type: text

oils_xpath_string(text, text, text)

Function Properties
Language: SQL
Return Type: text

oils_xpath_string(text, text, text, anyarray)

Function Properties
Language: SQL
Return Type: text

oils_xpath_table(criteria text, xpaths text, relation_name text, document_field text, key text)

Function Properties
Language: PLPGSQL
Return Type: SET OF record

oils_xslt_process(text, text)

Function Properties
Language: PLPERLU
Return Type: text

parse(oid, text)

Function Properties
Language: INTERNAL
Return Type: SET OF tokenout

parse(text)

Function Properties
Language: C
Return Type: SET OF tokenout

parse(text, text)

Function Properties
Language: INTERNAL
Return Type: SET OF tokenout

plainto_tsquery(oid, text)

Function Properties
Language: INTERNAL
Return Type: tsquery

plainto_tsquery(text)

Function Properties
Language: INTERNAL
Return Type: tsquery

plainto_tsquery(text, text)

Function Properties
Language: C
Return Type: tsquery

prsd_end(internal)

Function Properties
Language: C
Return Type: void

prsd_getlexeme(internal, internal, internal)

Function Properties
Language: C
Return Type: integer

prsd_headline(internal, internal, internal)

Function Properties
Language: C
Return Type: internal

prsd_lextype(internal)

Function Properties
Language: C
Return Type: internal

prsd_start(internal, integer)

Function Properties
Language: C
Return Type: internal

querytree(tsquery)

Function Properties
Language: INTERNAL
Return Type: text

rank(real[], tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank(real[], tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

rank(tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank(tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(real[], tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(real[], tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(tsvector, tsquery)

Function Properties
Language: INTERNAL
Return Type: real

rank_cd(tsvector, tsquery, integer)

Function Properties
Language: INTERNAL
Return Type: real

remove_commas(text)

Function Properties
Language: SQL
Return Type: text

remove_diacritics(text)

Function Properties
Language: PLPERLU
Return Type: text

remove_paren_substring(text)

Function Properties
Language: SQL
Return Type: text

remove_whitespace(text)

Function Properties
Language: SQL
Return Type: text

reset_tsearch()

Function Properties
Language: C
Return Type: void

rewrite(tsquery, text)

Function Properties
Language: INTERNAL
Return Type: tsquery

rewrite(tsquery, tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

rewrite(tsquery[])

Function Properties
Language: INTERNAL
Return Type: tsquery

rewrite_accum(tsquery, tsquery[])

Function Properties
Language: C
Return Type: tsquery

rewrite_finish(tsquery)

Function Properties
Language: C
Return Type: tsquery

right_trunc(text, integer)

Function Properties
Language: SQL
Return Type: text

set_curcfg(integer)

Function Properties
Language: C
Return Type: void

set_curcfg(text)

Function Properties
Language: C
Return Type: void

set_curdict(integer)

Function Properties
Language: C
Return Type: void

set_curdict(text)

Function Properties
Language: C
Return Type: void

set_curprs(integer)

Function Properties
Language: C
Return Type: void

set_curprs(text)

Function Properties
Language: C
Return Type: void

setweight(tsvector, "char")

Function Properties
Language: INTERNAL
Return Type: tsvector

show_curcfg()

Function Properties
Language: INTERNAL
Return Type: oid

snb_en_init(internal)

Function Properties
Language: C
Return Type: internal

snb_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

snb_ru_init(internal)

Function Properties
Language: C
Return Type: internal

snb_ru_init_koi8(internal)

Function Properties
Language: C
Return Type: internal

snb_ru_init_utf8(internal)

Function Properties
Language: C
Return Type: internal

spell_init(internal)

Function Properties
Language: C
Return Type: internal

spell_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

split_date_range(text)

Function Properties
Language: SQL
Return Type: text

stat(text)

Function Properties
Language: INTERNAL
Return Type: SET OF statinfo

stat(text, text)

Function Properties
Language: INTERNAL
Return Type: SET OF statinfo

strip(tsvector)

Function Properties
Language: INTERNAL
Return Type: tsvector

syn_init(internal)

Function Properties
Language: C
Return Type: internal

syn_lexize(internal, internal, integer)

Function Properties
Language: C
Return Type: internal

tableoid2name(oid)

Function Properties
Language: PLPGSQL
Return Type: text

text_concat(text, text)

Function Properties
Language: SQL
Return Type: text

thesaurus_init(internal)

Function Properties
Language: C
Return Type: internal

thesaurus_lexize(internal, internal, integer, internal)

Function Properties
Language: C
Return Type: internal

to_tsquery(oid, text)

Function Properties
Language: INTERNAL
Return Type: tsquery

to_tsquery(text)

Function Properties
Language: INTERNAL
Return Type: tsquery

to_tsquery(text, text)

Function Properties
Language: C
Return Type: tsquery

to_tsvector(oid, text)

Function Properties
Language: INTERNAL
Return Type: tsvector

to_tsvector(text)

Function Properties
Language: INTERNAL
Return Type: tsvector

to_tsvector(text, text)

Function Properties
Language: C
Return Type: tsvector

token_type()

Function Properties
Language: C
Return Type: SET OF tokentype

token_type(integer)

Function Properties
Language: INTERNAL
Return Type: SET OF tokentype

token_type(text)

Function Properties
Language: INTERNAL
Return Type: SET OF tokentype

translate_isbn1013(text)

The translate_isbn1013 function takes an input ISBN and returns the following in a single space-delimited string if the input ISBN is valid: - The normalized input ISBN (hyphens stripped) - The normalized input ISBN with a fixed checksum if the checksum was bad - The ISBN converted to its ISBN10 or ISBN13 counterpart, if possible

Function Properties
Language: PLPERLU
Return Type: text

ts_debug(text)

Function Properties
Language: SQL
Return Type: SET OF tsdebug

tsearch2()

Function Properties
Language: C
Return Type: trigger

tsq_mcontained(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: boolean

tsq_mcontains(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: boolean

tsquery_and(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

tsquery_not(tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

tsquery_or(tsquery, tsquery)

Function Properties
Language: INTERNAL
Return Type: tsquery

tsvector_concat(tsvector, tsvector)

Function Properties
Language: SQL
Return Type: tsvector

uppercase(text)

Function Properties
Language: PLPERLU
Return Type: text

xml_encode_special_chars(text)

Function Properties
Language: C
Return Type: text

xml_is_well_formed(text)

Function Properties
Language: C
Return Type: boolean

xml_valid(text)

Function Properties
Language: C
Return Type: boolean

xpath_bool(text, text)

Function Properties
Language: C
Return Type: boolean

xpath_list(text, text)

Function Properties
Language: SQL
Return Type: text

xpath_list(text, text, text)

Function Properties
Language: C
Return Type: text

xpath_nodeset(text, text)

Function Properties
Language: SQL
Return Type: text

xpath_nodeset(text, text, text)

Function Properties
Language: SQL
Return Type: text

xpath_nodeset(text, text, text, text)

Function Properties
Language: C
Return Type: text

xpath_number(text, text)

Function Properties
Language: C
Return Type: real

xpath_string(text, text)

Function Properties
Language: C
Return Type: text

xpath_table(text, text, text, text, text)

Function Properties
Language: C
Return Type: SET OF record

xslt_process(text, text)

Function Properties
Language: C
Return Type: text

xslt_process(text, text, text)

Function Properties
Language: C
Return Type: text

Prev Up Next
Schema permission Home Schema query