Dumped on 2024-05-21

Index of database - wapt

public

deployconfig
hostauditdata
hostconfigs
hostgroups
hostosdeploy
hostpackagesstatus
hosts
hostsoftwares
hostsyncstatus
hostwebsocket
hostwsus
isoconfig
logsapi
messagestemplate
normalization
packages
reportingqueries
reportingsnapshots
serverattribs
siterules
syncstatus
waptbasemodel
waptroles
waptuseracls
waptusers
wsusdownloadtasks
wsusupdates
akeys(public.hstore)
avals(public.hstore)
defined(public.hstore, text)
delete(public.hstore, public.hstore)
delete(public.hstore, text)
delete(public.hstore, text[])
each(hs public.hstore)
exist(public.hstore, text)
exists_all(public.hstore, text[])
exists_any(public.hstore, text[])
fetchval(public.hstore, text)
ghstore_compress(internal)
ghstore_consistent(internal, public.hstore, smallint, oid, internal)
ghstore_decompress(internal)
ghstore_in(cstring)
ghstore_options(internal)
ghstore_out(public.ghstore)
ghstore_penalty(internal, internal, internal)
ghstore_picksplit(internal, internal)
ghstore_same(public.ghstore, public.ghstore, internal)
ghstore_union(internal, internal)
gin_consistent_hstore(internal, smallint, public.hstore, integer, internal, internal)
gin_extract_hstore(public.hstore, internal)
gin_extract_hstore_query(public.hstore, internal, smallint, internal, internal)
hs_concat(public.hstore, public.hstore)
hs_contained(public.hstore, public.hstore)
hs_contains(public.hstore, public.hstore)
hstore(record)
hstore(text, text)
hstore(text[])
hstore(text[], text[])
hstore_cmp(public.hstore, public.hstore)
hstore_eq(public.hstore, public.hstore)
hstore_ge(public.hstore, public.hstore)
hstore_gt(public.hstore, public.hstore)
hstore_hash(public.hstore)
hstore_hash_extended(public.hstore, bigint)
hstore_in(cstring)
hstore_le(public.hstore, public.hstore)
hstore_lt(public.hstore, public.hstore)
hstore_ne(public.hstore, public.hstore)
hstore_out(public.hstore)
hstore_recv(internal)
hstore_send(public.hstore)
hstore_subscript_handler(internal)
hstore_to_array(public.hstore)
hstore_to_json(public.hstore)
hstore_to_json_loose(public.hstore)
hstore_to_jsonb(public.hstore)
hstore_to_jsonb_loose(public.hstore)
hstore_to_matrix(public.hstore)
hstore_version_diag(public.hstore)
isdefined(public.hstore, text)
isexists(public.hstore, text)
populate_record(anyelement, public.hstore)
skeys(public.hstore)
slice(public.hstore, text[])
slice_array(public.hstore, text[])
svals(public.hstore)
tconvert(text, text)
update_host_sync_status()

Table: deployconfig

deployconfig Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
signature_date	text
signer	text
signer_fingerprint	text
signer_certificate	text
signed_attributes	jsonb
signature	text
name	text
os_type	text
xml_conf	text
iso_config_name	text
script_postinstall	text
install_wapt	boolean
ipxe_script	text

deployconfig_signed_attributes signed_attributes

Index - Schema public

Table: hostauditdata

hostauditdata Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
hosts.uuid	host_id	character varying(255)	NOT NULL
	value_id	bigint
	value_date	text	NOT NULL
	value_section	text
	value_key	text	NOT NULL
	value	jsonb
	expiration_date	text
	created_on	timestamp without time zone
	created_by	character varying(255)

hostauditdata_expiration_date expiration_date
hostauditdata_host_id host_id
hostauditdata_hostid host_id, value_key, value_date
hostauditdata_value value
hostauditdata_value_date value_date
hostauditdata_value_id value_id
hostauditdata_value_key value_key

Index - Schema public

Table: hostconfigs

hostconfigs Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
	created_on	timestamp without time zone
	created_by	character varying(255)
	updated_on	timestamp without time zone
	updated_by	character varying(255)
	config	json
	priorities	json
hosts.uuid	host_id	character varying(255)	NOT NULL

hostconfigs_host_id host_id

Index - Schema public

Table: hostgroups

hostgroups Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	created_on	timestamp without time zone
	created_by	character varying(255)
	updated_on	timestamp without time zone
	updated_by	character varying(255)
hosts.uuid	host_id	character varying(255)	NOT NULL
	group_name	character varying(255)	NOT NULL

hostgroups_group_name group_name
hostgroups_host_id host_id

Index - Schema public

Table: hostosdeploy

hostosdeploy Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
signature_date	text
signer	text
signer_fingerprint	text
signer_certificate	text
signed_attributes	jsonb
signature	text
mac_addresses	text
status	text
waiting_to_deploy	boolean
uuid	text
hostname	text
deploy_config_name	text
product_key	text
driver_bundle	text
disk_format	text
djoin	text
manufacturer	text
product	text
serial_number	text
asset	text
ei_cfg	text
pid_txt	text
diskpart_list_disk	text
diskpart_list_vol	text
ip_address	text
use_ip_from_winpe	boolean

hostosdeploy_signed_attributes signed_attributes

Index - Schema public

Table: hostpackagesstatus

hostpackagesstatus Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	created_on	timestamp without time zone
	created_by	character varying(255)
	updated_on	timestamp without time zone
	updated_by	character varying(255)
hosts.uuid	host_id	character varying(255)	NOT NULL
	install_id	integer
	package_uuid	character varying(255)
	name	character varying(255)
	package	character varying(255)
	version	character varying(255)
	architecture	character varying(255)
	locale	character varying(255)
	maturity	character varying(255)
	section	character varying(255)
	priority	character varying(255)
	signer	character varying(255)
	signer_fingerprint	character varying(255)
	signature_date	character varying(255)
	description	text
	impacted_process	character varying(255)[]
	install_status	character varying(255)
	install_date	character varying(255)
	install_output	text
	install_params	character varying(255)
	uninstall_key	character varying(255)[]
	explicit_by	character varying(255)
	repo_url	character varying(600)
	depends	character varying(255)[]
	conflicts	character varying(255)[]
	last_audit_status	character varying(255)
	last_audit_on	character varying(255)
	last_audit_output	text
	next_audit_on	character varying(255)

hostpackagesstatus_conflicts conflicts
hostpackagesstatus_depends depends
hostpackagesstatus_host_id host_id
hostpackagesstatus_impacted_process impacted_process
hostpackagesstatus_package package
hostpackagesstatus_uninstall_key uninstall_key

Index - Schema public

Table: hosts

hosts Structure
Name	Type	Description
uuid	character varying(255)	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
computer_fqdn	character varying(255)
description	character varying(255)
computer_name	character varying(255)
computer_type	character varying(255)
computer_architecture	character varying(255)
manufacturer	character varying(255)
productname	character varying(255)
serialnr	character varying(255)
host_certificate	text
registration_auth_user	character varying(255)
authorized_certificates_sha256	character varying(255)[]
os_name	character varying(255)
os_version	character varying(255)
os_architecture	character varying(255)
platform	character varying(255)
connected_users	character varying(255)[]
connected_ips	character varying(255)[]
mac_addresses	character varying(255)[]
gateways	character varying(255)[]
networks	character varying(255)[]
dnsdomain	character varying(255)
computer_ad_site	character varying(255)
computer_ad_ou	character varying(255)
computer_ad_groups	character varying(255)[]
server_uuid	character varying(255)
repositories	character varying(255)
host_status	character varying(255)
last_seen_on	character varying(255)
last_logged_on_user	character varying(255)
audit_status	character varying(255)
wapt_version	character varying(255)
wapt_status	jsonb
last_update_status	jsonb
host_info	jsonb
host_capabilities	jsonb
host_metrics	jsonb
host_networking	jsonb
host_packages_filter	text
dmi	jsonb
wmi	jsonb
wuauserv_status	jsonb
waptwua_status	jsonb
waptwua_rules	jsonb
status_hashes	jsonb

Tables referencing this one via Foreign Key Constraints:

hostauditdata

hostconfigs

hostgroups

hostpackagesstatus

hostsoftwares

hostwebsocket

hostwsus

hosts_authorized_certificates_sha256 authorized_certificates_sha256
hosts_computer_ad_groups computer_ad_groups
hosts_computer_ad_ou computer_ad_ou
hosts_computer_ad_site computer_ad_site
hosts_computer_fqdn computer_fqdn
hosts_connected_ips connected_ips
hosts_connected_users connected_users
hosts_description description
hosts_gateways gateways
hosts_host_capabilities host_capabilities
hosts_host_info host_info
hosts_host_metrics host_metrics
hosts_host_networking host_networking
hosts_host_packages_filter host_packages_filter
hosts_mac_addresses mac_addresses
hosts_networks networks
hosts_wapt_status wapt_status
hosts_wmi wmi

Index - Schema public

Table: hostsoftwares

hostsoftwares Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	created_on	timestamp without time zone
	created_by	character varying(255)
	updated_on	timestamp without time zone
	updated_by	character varying(255)
hosts.uuid	host_id	character varying(255)	NOT NULL
	software_id	character varying(600)
	name	character varying(2000)
	version	character varying(1000)
	publisher	character varying(2000)
	key	character varying(600)
	system_component	character varying(255)
	uninstall_string	character varying(2000)
	install_date	character varying(255)
	install_location	character varying(2000)

hostsoftwares_host_id host_id
hostsoftwares_host_key host_id, key
hostsoftwares_name name

Index - Schema public

Table: hostsyncstatus

hostsyncstatus Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
uuid	character varying(255)	NOT NULL
status	character varying(255)
current_download	text
last_sync	timestamp without time zone
last_audit	timestamp without time zone
current_speed	character varying(255)
speed_average	character varying(255)
errors	json
progress	real
sync_id	integer
version	integer

Index - Schema public

Table: hostwebsocket

hostwebsocket Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
hosts.uuid	host_id	character varying(255)	NOT NULL
	server_uuid	character varying(255)
	session_id	character varying(255)
	timestamp	bigint

hostwebsocket_session_id session_id

Index - Schema public

Table: hostwsus

hostwsus Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	created_on	timestamp without time zone
	created_by	character varying(255)
	updated_on	timestamp without time zone
	updated_by	character varying(255)
hosts.uuid	host_id	character varying(255)	NOT NULL
wsusupdates.update_id	update_id	character varying(255)	NOT NULL
	status	character varying(255)
	allowed	boolean
	installed	boolean
	present	boolean
	hidden	boolean
	delayed	boolean
	downloaded	boolean
	install_date	character varying(255)
	history	jsonb

hostwsus_host_id host_id
hostwsus_update_id update_id

Index - Schema public

Table: isoconfig

isoconfig Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
signature_date	text
signer	text
signer_fingerprint	text
signer_certificate	text
signed_attributes	jsonb
signature	text
name	text
architecture	text
hash	text

isoconfig_signed_attributes signed_attributes

Index - Schema public

Table: logsapi

logsapi Structure
Name	Type	Description
id	bigserial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
endpoint	text
args	json
data	text
forbidden	boolean
authenticated	boolean
user	text
user_acls	text
host	text
remote_addr	text
header_user_agent	text
method	text
scheme	text
path	text
full_path	text

Index - Schema public

Table: messagestemplate

messagestemplate Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
name	text
html_content	text
user	text

Index - Schema public

Table: normalization

normalization Structure
Name	Type	Description
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
original_name	text	PRIMARY KEY
key	text	PRIMARY KEY
normalized_name	text
banned	boolean
windows_update	boolean

normalization_normalized_name normalized_name

Index - Schema public

Table: packages

packages Structure
Name	Type	Description
id	bigserial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
package_uuid	character varying(255)
package	character varying(255)	NOT NULL
version	character varying(255)	NOT NULL
architecture	character varying(255)[]
locale	character varying(255)[]
maturity	character varying(255)
section	character varying(255)
priority	character varying(255)
signer	character varying(255)
signer_fingerprint	character varying(255)
signature_date	character varying(255)
description	text
depends	character varying(255)[]
conflicts	character varying(255)[]
audit_schedule	character varying(255)
valid_from	character varying(255)
valid_until	character varying(255)
forced_install_on	character varying(255)
installed_size	bigint
target_os	character varying(255)[]
min_os_version	character varying(255)
max_os_version	character varying(255)
min_wapt_version	character varying(255)
impacted_process	character varying(255)[]
keywords	character varying(255)[]
name	character varying(255)
categories	character varying(255)[]
licence	character varying(255)[]
editor	character varying(255)
homepage	character varying(255)
icon_sha256sum	character varying(255)
is_available	boolean
changelog	text
maintainer	text
md5sum	text
sources	text
size	bigint
filename	text
description_localized	jsonb

packages_architecture architecture
packages_categories categories
packages_conflicts conflicts
packages_depends depends
packages_description_localized description_localized
packages_impacted_process impacted_process
packages_keywords keywords
packages_licence licence
packages_locale locale
packages_package package
packages_target_os target_os

Index - Schema public

Table: reportingqueries

reportingqueries Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
name	character varying(255)	NOT NULL
query	text
settings	jsonb
snapshot_scheduling	character varying(255)
snapshot_name	character varying(255)
last_snapshot_date	bigint
snapshot_ttl	integer
as_host_uuid	character varying(255)
as_package_uuid	character varying(255)
as_kb_update_id	character varying(255)
as_software_key	character varying(255)

Tables referencing this one via Foreign Key Constraints:

reportingsnapshots

reportingqueries_name name

Index - Schema public

Table: reportingsnapshots

reportingsnapshots Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
reportingqueries.id	report_id	integer	NOT NULL
	report_name	character varying(255)	NOT NULL
	report_date	timestamp without time zone
	row_nr	bigint
	row_data	jsonb

reportingsnapshots_report_id report_id
reportingsnapshots_report_name report_name, report_date, row_nr
reportingsnapshots_row_data row_data

Index - Schema public

Table: serverattribs

serverattribs Structure
F-Key	Name	Type	Description
	key	character varying(255)	PRIMARY KEY
	value	jsonb

serverattribs_value value

Index - Schema public

Table: siterules

siterules Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
sequence	integer
name	character varying(255)
repositories	json
condition	character varying(255)
value	character varying(255)
repo_url	character varying(255)
signature_date	character varying(255)
signed_attributes	json
signer	character varying(255)
signature	text
signer_certificate	text
negation	boolean
no_fallback	boolean
has_proxy	boolean
http_proxy	text
signer_fingerprint	character varying(255)

Index - Schema public

Table: syncstatus

syncstatus Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
version	integer
changelog	json
progress	integer

Index - Schema public

Table: waptbasemodel

waptbasemodel Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)

Index - Schema public

Table: waptroles

waptroles Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
name	character varying(255)	NOT NULL
description	character varying(255)	NOT NULL
acls	json
signer	character varying(255)
signature_date	character varying(255)
signer_fingerprint	character varying(255)
signature	character varying(255)

waptroles_name name

Index - Schema public

Table: waptuseracls

waptuseracls Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
username	character varying(255)	NOT NULL
user_fingerprint	character varying(255)
user_fingerprint_sha1	character varying(255)
acls	json
expiration_date	character varying(255)
signer	character varying(255)
signer_fingerprint	character varying(255)
signature_date	character varying(255)
signed_attributes	jsonb
signer_certificate	text
signature	text

waptuseracls_signed_attributes signed_attributes
waptuseracls_user_fingerprint user_fingerprint
waptuseracls_user_fingerprint_sha1 user_fingerprint_sha1

Index - Schema public

Table: waptusers

waptusers Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
name	character varying(255)
auth_method	character varying(255)
description	character varying(255)
user_certificate	text
user_fingerprint	character varying(255)
user_fingerprint_sha1	character varying(255)
last_login_timestamp	bigint

waptusers_user_fingerprint user_fingerprint
waptusers_user_fingerprint_sha1 user_fingerprint_sha1

Index - Schema public

Table: wsusdownloadtasks

wsusdownloadtasks Structure
Name	Type	Description
id	serial	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
task_id	character varying(255)
kind	character varying(255)
url	character varying(255)
target_size	bigint
local_filename	character varying(255)
file_date	timestamp without time zone
file_size	bigint
status	character varying(255)
started_on	timestamp without time zone
finished_on	timestamp without time zone
msg	character varying(255)
forced	boolean
skipped	boolean
error	character varying(1200)

wsusdownloadtasks_finished_on finished_on
wsusdownloadtasks_kind kind
wsusdownloadtasks_started_on started_on
wsusdownloadtasks_task_id task_id

Index - Schema public

Table: wsusupdates

wsusupdates Structure
Name	Type	Description
update_id	character varying(255)	PRIMARY KEY
created_on	timestamp without time zone
created_by	character varying(255)
updated_on	timestamp without time zone
updated_by	character varying(255)
title	character varying(255)	NOT NULL
update_type	character varying(255)	NOT NULL
kbids	character varying(255)[]
severity	character varying(255)
changetime	character varying(255)
product	character varying(255)
classification	character varying(255)
download_urls	character varying(255)[]
min_download_size	bigint
max_download_size	bigint
superseded_update_ids	character varying(255)[]
security_bulletin_ids	character varying(255)[]
cve_ids	character varying(255)[]
is_mandatory	boolean
reboot_behaviour	character varying(255)
can_request_user_input	character varying(255)
requires_network_connectivity	boolean
is_beta	boolean
is_uninstallable	boolean
installation_impact	character varying(255)
uninstallation_impact	character varying(255)
support_url	character varying(255)
release_notes	text
uninstallation_notes	text
languages	character varying(255)[]
downloaded_on	character varying(255)

Tables referencing this one via Foreign Key Constraints:

hostwsus

wsusupdates_cve_ids cve_ids
wsusupdates_download_urls download_urls
wsusupdates_kbids kbids
wsusupdates_languages languages
wsusupdates_product product
wsusupdates_security_bulletin_ids security_bulletin_ids
wsusupdates_superseded_update_ids superseded_update_ids

Index - Schema public

Function: akeys(public.hstore)

Returns: text[]

Language: C

hstore_akeys

Function: avals(public.hstore)

Returns: text[]

Language: C

hstore_avals

Function: defined(public.hstore, text)

Returns: boolean

Language: C

hstore_defined

Function: delete(public.hstore, public.hstore)

Returns: hstore

Language: C

hstore_delete_hstore

Function: delete(public.hstore, text)

Returns: hstore

Language: C

hstore_delete

Function: delete(public.hstore, text[])

Returns: hstore

Language: C

hstore_delete_array

Function: each(hs public.hstore)

Returns: SET OF record

Language: C

hstore_each

Function: exist(public.hstore, text)

Returns: boolean

Language: C

hstore_exists

Function: exists_all(public.hstore, text[])

Returns: boolean

Language: C

hstore_exists_all

Function: exists_any(public.hstore, text[])

Returns: boolean

Language: C

hstore_exists_any

Function: fetchval(public.hstore, text)

Returns: text

Language: C

hstore_fetchval

Function: ghstore_compress(internal)

Returns: internal

Language: C

ghstore_compress

Function: ghstore_consistent(internal, public.hstore, smallint, oid, internal)

Returns: boolean

Language: C

ghstore_consistent

Function: ghstore_decompress(internal)

Returns: internal

Language: C

ghstore_decompress

Function: ghstore_in(cstring)

Returns: ghstore

Language: C

ghstore_in

Function: ghstore_options(internal)

Returns: void

Language: C

ghstore_options

Function: ghstore_out(public.ghstore)

Returns: cstring

Language: C

ghstore_out

Function: ghstore_penalty(internal, internal, internal)

Returns: internal

Language: C

ghstore_penalty

Function: ghstore_picksplit(internal, internal)

Returns: internal

Language: C

ghstore_picksplit

Function: ghstore_same(public.ghstore, public.ghstore, internal)

Returns: internal

Language: C

ghstore_same

Function: ghstore_union(internal, internal)

Returns: ghstore

Language: C

ghstore_union

Function: gin_consistent_hstore(internal, smallint, public.hstore, integer, internal, internal)

Returns: boolean

Language: C

gin_consistent_hstore

Function: gin_extract_hstore(public.hstore, internal)

Returns: internal

Language: C

gin_extract_hstore

Function: gin_extract_hstore_query(public.hstore, internal, smallint, internal, internal)

Returns: internal

Language: C

gin_extract_hstore_query

Function: hs_concat(public.hstore, public.hstore)

Returns: hstore

Language: C

hstore_concat

Function: hs_contained(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_contained

Function: hs_contains(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_contains

Function: hstore(record)

Returns: hstore

Language: C

hstore_from_record

Function: hstore(text, text)

Returns: hstore

Language: C

hstore_from_text

Function: hstore(text[])

Returns: hstore

Language: C

hstore_from_array

Function: hstore(text[], text[])

Returns: hstore

Language: C

hstore_from_arrays

Function: hstore_cmp(public.hstore, public.hstore)

Returns: integer

Language: C

hstore_cmp

Function: hstore_eq(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_eq

Function: hstore_ge(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_ge

Function: hstore_gt(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_gt

Function: hstore_hash(public.hstore)

Returns: integer

Language: C

hstore_hash

Function: hstore_hash_extended(public.hstore, bigint)

Returns: bigint

Language: C

hstore_hash_extended

Function: hstore_in(cstring)

Returns: hstore

Language: C

hstore_in

Function: hstore_le(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_le

Function: hstore_lt(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_lt

Function: hstore_ne(public.hstore, public.hstore)

Returns: boolean

Language: C

hstore_ne

Function: hstore_out(public.hstore)

Returns: cstring

Language: C

hstore_out

Function: hstore_recv(internal)

Returns: hstore

Language: C

hstore_recv

Function: hstore_send(public.hstore)

Returns: bytea

Language: C

hstore_send

Function: hstore_subscript_handler(internal)

Returns: internal

Language: C

hstore_subscript_handler

Function: hstore_to_array(public.hstore)

Returns: text[]

Language: C

hstore_to_array

Function: hstore_to_json(public.hstore)

Returns: json

Language: C

hstore_to_json

Function: hstore_to_json_loose(public.hstore)

Returns: json

Language: C

hstore_to_json_loose

Function: hstore_to_jsonb(public.hstore)

Returns: jsonb

Language: C

hstore_to_jsonb

Function: hstore_to_jsonb_loose(public.hstore)

Returns: jsonb

Language: C

hstore_to_jsonb_loose

Function: hstore_to_matrix(public.hstore)

Returns: text[]

Language: C

hstore_to_matrix

Function: hstore_version_diag(public.hstore)

Returns: integer

Language: C

hstore_version_diag

Function: isdefined(public.hstore, text)

Returns: boolean

Language: C

hstore_defined

Function: isexists(public.hstore, text)

Returns: boolean

Language: C

hstore_exists

Function: populate_record(anyelement, public.hstore)

Returns: anyelement

Language: C

hstore_populate_record

Function: skeys(public.hstore)

Returns: SET OF text

Language: C

hstore_skeys

Function: slice(public.hstore, text[])

Returns: hstore

Language: C

hstore_slice_to_hstore

Function: slice_array(public.hstore, text[])

Returns: text[]

Language: C

hstore_slice_to_array

Function: svals(public.hstore)

Returns: SET OF text

Language: C

hstore_svals

Function: tconvert(text, text)

Returns: hstore

Language: C

hstore_from_text

Function: update_host_sync_status()

Returns: trigger

Language: PLPGSQL

                BEGIN
                    IF (TG_OP = 'INSERT') THEN
                        IF ((NEW.wapt_status->>'is_remote_repo')::boolean=True) THEN
                            INSERT INTO hostsyncstatus (uuid) VALUES (NEW.uuid);
                        END IF;
                        RETURN NEW;
                    ELSEIF (TG_OP = 'UPDATE') THEN
                        IF ((NEW.wapt_status->>'is_remote_repo')::boolean=True) THEN
                            IF NOT EXISTS (SELECT 1 FROM hostsyncstatus WHERE uuid = NEW.uuid) THEN
                                INSERT INTO hostsyncstatus (uuid) VALUES (NEW.uuid);
                            END IF;
                        ELSE
                            DELETE FROM hostsyncstatus WHERE hostsyncstatus.uuid = OLD.uuid;
                        END IF;
                        RETURN NEW;
                    ELSE
                        DELETE FROM hostsyncstatus WHERE hostsyncstatus.uuid = OLD.uuid;
                        RETURN OLD;
                    END IF;
                END

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict