| 826 |
pg_catalog |
pg_default_acl |
'**[' || (coalesce(defaclrole::text, '') || ';' || coalesce(defaclnamespace::text, '') || ';' || coalesce(defaclobjtype::text, '')) || ']( ' || '../form/pg_default_acl' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_default_acl
, defaclrole as defaclrole
, defaclnamespace as defaclnamespace
, defaclobjtype as defaclobjtype
, defaclacl as defaclacl
|
, 'pg_default_acl' as markdown, 'defaclrole' as markdown, 'defaclnamespace' as markdown, 'defaclobjtype' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_default_acl' || '=**' || (select coalesce(defaclrole::text, '') || ';' || coalesce(defaclnamespace::text, '') || ';' || coalesce(defaclobjtype::text, '') from pg_default_acl where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'defaclrole' is not null then 'defaclrole' || '=' || (($filter::jsonb)->>'defaclrole') end , case when ($filter::jsonb)->>'defaclnamespace' is not null then 'defaclnamespace' || '=' || (($filter::jsonb)->>'defaclnamespace') end , case when ($filter::jsonb)->>'defaclobjtype' is not null then 'defaclobjtype' || '=' || (($filter::jsonb)->>'defaclobjtype') end , case when ($filter::jsonb)->>'defaclacl' is not null then 'defaclacl' || '=' || (($filter::jsonb)->>'defaclacl') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'defaclrole' is null or (($filter::jsonb)->>'defaclrole')::oid = defaclrole) and (($filter::jsonb)->>'defaclnamespace' is null or (($filter::jsonb)->>'defaclnamespace')::oid = defaclnamespace) and (($filter::jsonb)->>'defaclobjtype' is null or (($filter::jsonb)->>'defaclobjtype')::"char" = defaclobjtype) and (($filter::jsonb)->>'defaclacl' is null or (($filter::jsonb)->>'defaclacl')::_aclitem = defaclacl))) |
|
|
| 1213 |
pg_catalog |
pg_tablespace |
'**[' || (coalesce(spcname::text, '')) || ']( ' || '../form/pg_tablespace' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_tablespace
, spcname as spcname
, spcowner as spcowner
, spcacl as spcacl
, spcoptions as spcoptions
|
, 'pg_tablespace' as markdown, 'spcname' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_tablespace' || '=**' || (select coalesce(spcname::text, '') from pg_tablespace where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'spcname' is not null then 'spcname' || '=' || (($filter::jsonb)->>'spcname') end , case when ($filter::jsonb)->>'spcowner' is not null then 'spcowner' || '=' || (($filter::jsonb)->>'spcowner') end , case when ($filter::jsonb)->>'spcacl' is not null then 'spcacl' || '=' || (($filter::jsonb)->>'spcacl') end , case when ($filter::jsonb)->>'spcoptions' is not null then 'spcoptions' || '=' || (($filter::jsonb)->>'spcoptions') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'spcname' is null or (($filter::jsonb)->>'spcname')::name = spcname) and (($filter::jsonb)->>'spcowner' is null or (($filter::jsonb)->>'spcowner')::oid = spcowner) and (($filter::jsonb)->>'spcacl' is null or (($filter::jsonb)->>'spcacl')::_aclitem = spcacl) and (($filter::jsonb)->>'spcoptions' is null or (($filter::jsonb)->>'spcoptions')::_text = spcoptions))) |
|
|
| 1214 |
pg_catalog |
pg_shdepend |
dbid as dbid
, classid as classid
, objid as objid
, objsubid as objsubid
, refclassid as refclassid
, refobjid as refobjid
, deptype as deptype
|
|
|
|
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'dbid' is not null then 'dbid' || '=' || (($filter::jsonb)->>'dbid') end , case when ($filter::jsonb)->>'classid' is not null then 'classid' || '=' || (($filter::jsonb)->>'classid') end , case when ($filter::jsonb)->>'objid' is not null then 'objid' || '=' || (($filter::jsonb)->>'objid') end , case when ($filter::jsonb)->>'objsubid' is not null then 'objsubid' || '=' || (($filter::jsonb)->>'objsubid') end , case when ($filter::jsonb)->>'refclassid' is not null then 'refclassid' || '=' || (($filter::jsonb)->>'refclassid') end , case when ($filter::jsonb)->>'refobjid' is not null then 'refobjid' || '=' || (($filter::jsonb)->>'refobjid') end , case when ($filter::jsonb)->>'deptype' is not null then 'deptype' || '=' || (($filter::jsonb)->>'deptype') end ) |
($filter is null or ((($filter::jsonb)->>'dbid' is null or (($filter::jsonb)->>'dbid')::oid = dbid) and (($filter::jsonb)->>'classid' is null or (($filter::jsonb)->>'classid')::oid = classid) and (($filter::jsonb)->>'objid' is null or (($filter::jsonb)->>'objid')::oid = objid) and (($filter::jsonb)->>'objsubid' is null or (($filter::jsonb)->>'objsubid')::int4 = objsubid) and (($filter::jsonb)->>'refclassid' is null or (($filter::jsonb)->>'refclassid')::oid = refclassid) and (($filter::jsonb)->>'refobjid' is null or (($filter::jsonb)->>'refobjid')::oid = refobjid) and (($filter::jsonb)->>'deptype' is null or (($filter::jsonb)->>'deptype')::"char" = deptype))) |
|
|
| 1247 |
pg_catalog |
pg_type |
'**[' || (coalesce(typname::text, '') || ';' || coalesce(typnamespace::text, '')) || ']( ' || '../form/pg_type' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_type
, typname as typname
, typnamespace as typnamespace
, typowner as typowner
, typlen as typlen
, typbyval as typbyval
, typtype as typtype
, typcategory as typcategory
, typispreferred as typispreferred
, typisdefined as typisdefined
, typdelim as typdelim
, typrelid as typrelid
, typsubscript as typsubscript
, typelem as typelem
, typarray as typarray
, typinput as typinput
, typoutput as typoutput
, typreceive as typreceive
, typsend as typsend
, typmodin as typmodin
, typmodout as typmodout
, typanalyze as typanalyze
, typalign as typalign
, typstorage as typstorage
, typnotnull as typnotnull
, typbasetype as typbasetype
, typtypmod as typtypmod
, typndims as typndims
, typcollation as typcollation
, typdefaultbin as typdefaultbin
, typdefault as typdefault
, typacl as typacl
|
, 'pg_type' as markdown, 'typname' as markdown, 'typnamespace' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_type' || '=**' || (select coalesce(typname::text, '') || ';' || coalesce(typnamespace::text, '') from pg_type where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'typname' is not null then 'typname' || '=' || (($filter::jsonb)->>'typname') end , case when ($filter::jsonb)->>'typnamespace' is not null then 'typnamespace' || '=' || (($filter::jsonb)->>'typnamespace') end , case when ($filter::jsonb)->>'typowner' is not null then 'typowner' || '=' || (($filter::jsonb)->>'typowner') end , case when ($filter::jsonb)->>'typlen' is not null then 'typlen' || '=' || (($filter::jsonb)->>'typlen') end , case when ($filter::jsonb)->>'typbyval' is not null then 'typbyval' || '=' || (($filter::jsonb)->>'typbyval') end , case when ($filter::jsonb)->>'typtype' is not null then 'typtype' || '=' || (($filter::jsonb)->>'typtype') end , case when ($filter::jsonb)->>'typcategory' is not null then 'typcategory' || '=' || (($filter::jsonb)->>'typcategory') end , case when ($filter::jsonb)->>'typispreferred' is not null then 'typispreferred' || '=' || (($filter::jsonb)->>'typispreferred') end , case when ($filter::jsonb)->>'typisdefined' is not null then 'typisdefined' || '=' || (($filter::jsonb)->>'typisdefined') end , case when ($filter::jsonb)->>'typdelim' is not null then 'typdelim' || '=' || (($filter::jsonb)->>'typdelim') end , case when ($filter::jsonb)->>'typrelid' is not null then 'typrelid' || '=' || (($filter::jsonb)->>'typrelid') end , case when ($filter::jsonb)->>'typsubscript' is not null then 'typsubscript' || '=' || (($filter::jsonb)->>'typsubscript') end , case when ($filter::jsonb)->>'typelem' is not null then 'typelem' || '=' || (($filter::jsonb)->>'typelem') end , case when ($filter::jsonb)->>'typarray' is not null then 'typarray' || '=' || (($filter::jsonb)->>'typarray') end , case when ($filter::jsonb)->>'typinput' is not null then 'typinput' || '=' || (($filter::jsonb)->>'typinput') end , case when ($filter::jsonb)->>'typoutput' is not null then 'typoutput' || '=' || (($filter::jsonb)->>'typoutput') end , case when ($filter::jsonb)->>'typreceive' is not null then 'typreceive' || '=' || (($filter::jsonb)->>'typreceive') end , case when ($filter::jsonb)->>'typsend' is not null then 'typsend' || '=' || (($filter::jsonb)->>'typsend') end , case when ($filter::jsonb)->>'typmodin' is not null then 'typmodin' || '=' || (($filter::jsonb)->>'typmodin') end , case when ($filter::jsonb)->>'typmodout' is not null then 'typmodout' || '=' || (($filter::jsonb)->>'typmodout') end , case when ($filter::jsonb)->>'typanalyze' is not null then 'typanalyze' || '=' || (($filter::jsonb)->>'typanalyze') end , case when ($filter::jsonb)->>'typalign' is not null then 'typalign' || '=' || (($filter::jsonb)->>'typalign') end , case when ($filter::jsonb)->>'typstorage' is not null then 'typstorage' || '=' || (($filter::jsonb)->>'typstorage') end , case when ($filter::jsonb)->>'typnotnull' is not null then 'typnotnull' || '=' || (($filter::jsonb)->>'typnotnull') end , case when ($filter::jsonb)->>'typbasetype' is not null then 'typbasetype' || '=' || (($filter::jsonb)->>'typbasetype') end , case when ($filter::jsonb)->>'typtypmod' is not null then 'typtypmod' || '=' || (($filter::jsonb)->>'typtypmod') end , case when ($filter::jsonb)->>'typndims' is not null then 'typndims' || '=' || (($filter::jsonb)->>'typndims') end , case when ($filter::jsonb)->>'typcollation' is not null then 'typcollation' || '=' || (($filter::jsonb)->>'typcollation') end , case when ($filter::jsonb)->>'typdefaultbin' is not null then 'typdefaultbin' || '=' || (($filter::jsonb)->>'typdefaultbin') end , case when ($filter::jsonb)->>'typdefault' is not null then 'typdefault' || '=' || (($filter::jsonb)->>'typdefault') end , case when ($filter::jsonb)->>'typacl' is not null then 'typacl' || '=' || (($filter::jsonb)->>'typacl') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'typname' is null or (($filter::jsonb)->>'typname')::name = typname) and (($filter::jsonb)->>'typnamespace' is null or (($filter::jsonb)->>'typnamespace')::oid = typnamespace) and (($filter::jsonb)->>'typowner' is null or (($filter::jsonb)->>'typowner')::oid = typowner) and (($filter::jsonb)->>'typlen' is null or (($filter::jsonb)->>'typlen')::int2 = typlen) and (($filter::jsonb)->>'typbyval' is null or (($filter::jsonb)->>'typbyval')::bool = typbyval) and (($filter::jsonb)->>'typtype' is null or (($filter::jsonb)->>'typtype')::"char" = typtype) and (($filter::jsonb)->>'typcategory' is null or (($filter::jsonb)->>'typcategory')::"char" = typcategory) and (($filter::jsonb)->>'typispreferred' is null or (($filter::jsonb)->>'typispreferred')::bool = typispreferred) and (($filter::jsonb)->>'typisdefined' is null or (($filter::jsonb)->>'typisdefined')::bool = typisdefined) and (($filter::jsonb)->>'typdelim' is null or (($filter::jsonb)->>'typdelim')::"char" = typdelim) and (($filter::jsonb)->>'typrelid' is null or (($filter::jsonb)->>'typrelid')::oid = typrelid) and (($filter::jsonb)->>'typsubscript' is null or (($filter::jsonb)->>'typsubscript')::regproc = typsubscript) and (($filter::jsonb)->>'typelem' is null or (($filter::jsonb)->>'typelem')::oid = typelem) and (($filter::jsonb)->>'typarray' is null or (($filter::jsonb)->>'typarray')::oid = typarray) and (($filter::jsonb)->>'typinput' is null or (($filter::jsonb)->>'typinput')::regproc = typinput) and (($filter::jsonb)->>'typoutput' is null or (($filter::jsonb)->>'typoutput')::regproc = typoutput) and (($filter::jsonb)->>'typreceive' is null or (($filter::jsonb)->>'typreceive')::regproc = typreceive) and (($filter::jsonb)->>'typsend' is null or (($filter::jsonb)->>'typsend')::regproc = typsend) and (($filter::jsonb)->>'typmodin' is null or (($filter::jsonb)->>'typmodin')::regproc = typmodin) and (($filter::jsonb)->>'typmodout' is null or (($filter::jsonb)->>'typmodout')::regproc = typmodout) and (($filter::jsonb)->>'typanalyze' is null or (($filter::jsonb)->>'typanalyze')::regproc = typanalyze) and (($filter::jsonb)->>'typalign' is null or (($filter::jsonb)->>'typalign')::"char" = typalign) and (($filter::jsonb)->>'typstorage' is null or (($filter::jsonb)->>'typstorage')::"char" = typstorage) and (($filter::jsonb)->>'typnotnull' is null or (($filter::jsonb)->>'typnotnull')::bool = typnotnull) and (($filter::jsonb)->>'typbasetype' is null or (($filter::jsonb)->>'typbasetype')::oid = typbasetype) and (($filter::jsonb)->>'typtypmod' is null or (($filter::jsonb)->>'typtypmod')::int4 = typtypmod) and (($filter::jsonb)->>'typndims' is null or (($filter::jsonb)->>'typndims')::int4 = typndims) and (($filter::jsonb)->>'typcollation' is null or (($filter::jsonb)->>'typcollation')::oid = typcollation) and (($filter::jsonb)->>'typdefaultbin' is null or (($filter::jsonb)->>'typdefaultbin')::pg_node_tree = typdefaultbin) and (($filter::jsonb)->>'typdefault' is null or (($filter::jsonb)->>'typdefault')::text = typdefault) and (($filter::jsonb)->>'typacl' is null or (($filter::jsonb)->>'typacl')::_aclitem = typacl))) |
|
|
| 1249 |
pg_catalog |
pg_attribute |
attnum as attnum
, attrelid as attrelid
, attname as attname
, atttypid as atttypid
, attlen as attlen
, atttypmod as atttypmod
, attndims as attndims
, attbyval as attbyval
, attalign as attalign
, attstorage as attstorage
, attcompression as attcompression
, attnotnull as attnotnull
, atthasdef as atthasdef
, atthasmissing as atthasmissing
, attidentity as attidentity
, attgenerated as attgenerated
, attisdropped as attisdropped
, attislocal as attislocal
, attinhcount as attinhcount
, attcollation as attcollation
, attstattarget as attstattarget
, attacl as attacl
, attoptions as attoptions
, attfdwoptions as attfdwoptions
, attmissingval as attmissingval
|
, 'pg_attribute' as markdown, 'pg_attribute' as markdown, 'attname' as markdown |
|
|
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'attnum' is not null then 'attnum' || '=' || (($filter::jsonb)->>'attnum') end , case when ($filter::jsonb)->>'attrelid' is not null then 'attrelid' || '=' || (($filter::jsonb)->>'attrelid') end , case when ($filter::jsonb)->>'attname' is not null then 'attname' || '=' || (($filter::jsonb)->>'attname') end , case when ($filter::jsonb)->>'atttypid' is not null then 'atttypid' || '=' || (($filter::jsonb)->>'atttypid') end , case when ($filter::jsonb)->>'attlen' is not null then 'attlen' || '=' || (($filter::jsonb)->>'attlen') end , case when ($filter::jsonb)->>'atttypmod' is not null then 'atttypmod' || '=' || (($filter::jsonb)->>'atttypmod') end , case when ($filter::jsonb)->>'attndims' is not null then 'attndims' || '=' || (($filter::jsonb)->>'attndims') end , case when ($filter::jsonb)->>'attbyval' is not null then 'attbyval' || '=' || (($filter::jsonb)->>'attbyval') end , case when ($filter::jsonb)->>'attalign' is not null then 'attalign' || '=' || (($filter::jsonb)->>'attalign') end , case when ($filter::jsonb)->>'attstorage' is not null then 'attstorage' || '=' || (($filter::jsonb)->>'attstorage') end , case when ($filter::jsonb)->>'attcompression' is not null then 'attcompression' || '=' || (($filter::jsonb)->>'attcompression') end , case when ($filter::jsonb)->>'attnotnull' is not null then 'attnotnull' || '=' || (($filter::jsonb)->>'attnotnull') end , case when ($filter::jsonb)->>'atthasdef' is not null then 'atthasdef' || '=' || (($filter::jsonb)->>'atthasdef') end , case when ($filter::jsonb)->>'atthasmissing' is not null then 'atthasmissing' || '=' || (($filter::jsonb)->>'atthasmissing') end , case when ($filter::jsonb)->>'attidentity' is not null then 'attidentity' || '=' || (($filter::jsonb)->>'attidentity') end , case when ($filter::jsonb)->>'attgenerated' is not null then 'attgenerated' || '=' || (($filter::jsonb)->>'attgenerated') end , case when ($filter::jsonb)->>'attisdropped' is not null then 'attisdropped' || '=' || (($filter::jsonb)->>'attisdropped') end , case when ($filter::jsonb)->>'attislocal' is not null then 'attislocal' || '=' || (($filter::jsonb)->>'attislocal') end , case when ($filter::jsonb)->>'attinhcount' is not null then 'attinhcount' || '=' || (($filter::jsonb)->>'attinhcount') end , case when ($filter::jsonb)->>'attcollation' is not null then 'attcollation' || '=' || (($filter::jsonb)->>'attcollation') end , case when ($filter::jsonb)->>'attstattarget' is not null then 'attstattarget' || '=' || (($filter::jsonb)->>'attstattarget') end , case when ($filter::jsonb)->>'attacl' is not null then 'attacl' || '=' || (($filter::jsonb)->>'attacl') end , case when ($filter::jsonb)->>'attoptions' is not null then 'attoptions' || '=' || (($filter::jsonb)->>'attoptions') end , case when ($filter::jsonb)->>'attfdwoptions' is not null then 'attfdwoptions' || '=' || (($filter::jsonb)->>'attfdwoptions') end , case when ($filter::jsonb)->>'attmissingval' is not null then 'attmissingval' || '=' || (($filter::jsonb)->>'attmissingval') end ) |
($filter is null or ((($filter::jsonb)->>'attnum' is null or (($filter::jsonb)->>'attnum')::int2 = attnum) and (($filter::jsonb)->>'attrelid' is null or (($filter::jsonb)->>'attrelid')::oid = attrelid) and (($filter::jsonb)->>'attname' is null or (($filter::jsonb)->>'attname')::name = attname) and (($filter::jsonb)->>'atttypid' is null or (($filter::jsonb)->>'atttypid')::oid = atttypid) and (($filter::jsonb)->>'attlen' is null or (($filter::jsonb)->>'attlen')::int2 = attlen) and (($filter::jsonb)->>'atttypmod' is null or (($filter::jsonb)->>'atttypmod')::int4 = atttypmod) and (($filter::jsonb)->>'attndims' is null or (($filter::jsonb)->>'attndims')::int2 = attndims) and (($filter::jsonb)->>'attbyval' is null or (($filter::jsonb)->>'attbyval')::bool = attbyval) and (($filter::jsonb)->>'attalign' is null or (($filter::jsonb)->>'attalign')::"char" = attalign) and (($filter::jsonb)->>'attstorage' is null or (($filter::jsonb)->>'attstorage')::"char" = attstorage) and (($filter::jsonb)->>'attcompression' is null or (($filter::jsonb)->>'attcompression')::"char" = attcompression) and (($filter::jsonb)->>'attnotnull' is null or (($filter::jsonb)->>'attnotnull')::bool = attnotnull) and (($filter::jsonb)->>'atthasdef' is null or (($filter::jsonb)->>'atthasdef')::bool = atthasdef) and (($filter::jsonb)->>'atthasmissing' is null or (($filter::jsonb)->>'atthasmissing')::bool = atthasmissing) and (($filter::jsonb)->>'attidentity' is null or (($filter::jsonb)->>'attidentity')::"char" = attidentity) and (($filter::jsonb)->>'attgenerated' is null or (($filter::jsonb)->>'attgenerated')::"char" = attgenerated) and (($filter::jsonb)->>'attisdropped' is null or (($filter::jsonb)->>'attisdropped')::bool = attisdropped) and (($filter::jsonb)->>'attislocal' is null or (($filter::jsonb)->>'attislocal')::bool = attislocal) and (($filter::jsonb)->>'attinhcount' is null or (($filter::jsonb)->>'attinhcount')::int2 = attinhcount) and (($filter::jsonb)->>'attcollation' is null or (($filter::jsonb)->>'attcollation')::oid = attcollation) and (($filter::jsonb)->>'attstattarget' is null or (($filter::jsonb)->>'attstattarget')::int2 = attstattarget) and (($filter::jsonb)->>'attacl' is null or (($filter::jsonb)->>'attacl')::_aclitem = attacl) and (($filter::jsonb)->>'attoptions' is null or (($filter::jsonb)->>'attoptions')::_text = attoptions) and (($filter::jsonb)->>'attfdwoptions' is null or (($filter::jsonb)->>'attfdwoptions')::_text = attfdwoptions) and (($filter::jsonb)->>'attmissingval' is null or (($filter::jsonb)->>'attmissingval')::anyarray = attmissingval))) |
|
|
| 1255 |
pg_catalog |
pg_proc |
'**[' || (coalesce(proname::text, '') || ';' || coalesce(pronamespace::text, '') || ';' || coalesce(proargtypes::text, '')) || ']( ' || '../form/pg_proc' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_proc
, proname as proname
, pronamespace as pronamespace
, proowner as proowner
, prolang as prolang
, procost as procost
, prorows as prorows
, provariadic as provariadic
, prosupport as prosupport
, prokind as prokind
, prosecdef as prosecdef
, proleakproof as proleakproof
, proisstrict as proisstrict
, proretset as proretset
, provolatile as provolatile
, proparallel as proparallel
, pronargs as pronargs
, pronargdefaults as pronargdefaults
, prorettype as prorettype
, proargtypes as proargtypes
, proallargtypes as proallargtypes
, proargmodes as proargmodes
, proargnames as proargnames
, proargdefaults as proargdefaults
, protrftypes as protrftypes
, prosrc as prosrc
, probin as probin
, prosqlbody as prosqlbody
, proconfig as proconfig
, proacl as proacl
|
, 'pg_proc' as markdown, 'proname' as markdown, 'pronamespace' as markdown, 'proargtypes' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_proc' || '=**' || (select coalesce(proname::text, '') || ';' || coalesce(pronamespace::text, '') || ';' || coalesce(proargtypes::text, '') from pg_proc where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'proname' is not null then 'proname' || '=' || (($filter::jsonb)->>'proname') end , case when ($filter::jsonb)->>'pronamespace' is not null then 'pronamespace' || '=' || (($filter::jsonb)->>'pronamespace') end , case when ($filter::jsonb)->>'proowner' is not null then 'proowner' || '=' || (($filter::jsonb)->>'proowner') end , case when ($filter::jsonb)->>'prolang' is not null then 'prolang' || '=' || (($filter::jsonb)->>'prolang') end , case when ($filter::jsonb)->>'procost' is not null then 'procost' || '=' || (($filter::jsonb)->>'procost') end , case when ($filter::jsonb)->>'prorows' is not null then 'prorows' || '=' || (($filter::jsonb)->>'prorows') end , case when ($filter::jsonb)->>'provariadic' is not null then 'provariadic' || '=' || (($filter::jsonb)->>'provariadic') end , case when ($filter::jsonb)->>'prosupport' is not null then 'prosupport' || '=' || (($filter::jsonb)->>'prosupport') end , case when ($filter::jsonb)->>'prokind' is not null then 'prokind' || '=' || (($filter::jsonb)->>'prokind') end , case when ($filter::jsonb)->>'prosecdef' is not null then 'prosecdef' || '=' || (($filter::jsonb)->>'prosecdef') end , case when ($filter::jsonb)->>'proleakproof' is not null then 'proleakproof' || '=' || (($filter::jsonb)->>'proleakproof') end , case when ($filter::jsonb)->>'proisstrict' is not null then 'proisstrict' || '=' || (($filter::jsonb)->>'proisstrict') end , case when ($filter::jsonb)->>'proretset' is not null then 'proretset' || '=' || (($filter::jsonb)->>'proretset') end , case when ($filter::jsonb)->>'provolatile' is not null then 'provolatile' || '=' || (($filter::jsonb)->>'provolatile') end , case when ($filter::jsonb)->>'proparallel' is not null then 'proparallel' || '=' || (($filter::jsonb)->>'proparallel') end , case when ($filter::jsonb)->>'pronargs' is not null then 'pronargs' || '=' || (($filter::jsonb)->>'pronargs') end , case when ($filter::jsonb)->>'pronargdefaults' is not null then 'pronargdefaults' || '=' || (($filter::jsonb)->>'pronargdefaults') end , case when ($filter::jsonb)->>'prorettype' is not null then 'prorettype' || '=' || (($filter::jsonb)->>'prorettype') end , case when ($filter::jsonb)->>'proargtypes' is not null then 'proargtypes' || '=' || (($filter::jsonb)->>'proargtypes') end , case when ($filter::jsonb)->>'proallargtypes' is not null then 'proallargtypes' || '=' || (($filter::jsonb)->>'proallargtypes') end , case when ($filter::jsonb)->>'proargmodes' is not null then 'proargmodes' || '=' || (($filter::jsonb)->>'proargmodes') end , case when ($filter::jsonb)->>'proargnames' is not null then 'proargnames' || '=' || (($filter::jsonb)->>'proargnames') end , case when ($filter::jsonb)->>'proargdefaults' is not null then 'proargdefaults' || '=' || (($filter::jsonb)->>'proargdefaults') end , case when ($filter::jsonb)->>'protrftypes' is not null then 'protrftypes' || '=' || (($filter::jsonb)->>'protrftypes') end , case when ($filter::jsonb)->>'prosrc' is not null then 'prosrc' || '=' || (($filter::jsonb)->>'prosrc') end , case when ($filter::jsonb)->>'probin' is not null then 'probin' || '=' || (($filter::jsonb)->>'probin') end , case when ($filter::jsonb)->>'prosqlbody' is not null then 'prosqlbody' || '=' || (($filter::jsonb)->>'prosqlbody') end , case when ($filter::jsonb)->>'proconfig' is not null then 'proconfig' || '=' || (($filter::jsonb)->>'proconfig') end , case when ($filter::jsonb)->>'proacl' is not null then 'proacl' || '=' || (($filter::jsonb)->>'proacl') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'proname' is null or (($filter::jsonb)->>'proname')::name = proname) and (($filter::jsonb)->>'pronamespace' is null or (($filter::jsonb)->>'pronamespace')::oid = pronamespace) and (($filter::jsonb)->>'proowner' is null or (($filter::jsonb)->>'proowner')::oid = proowner) and (($filter::jsonb)->>'prolang' is null or (($filter::jsonb)->>'prolang')::oid = prolang) and (($filter::jsonb)->>'procost' is null or (($filter::jsonb)->>'procost')::float4 = procost) and (($filter::jsonb)->>'prorows' is null or (($filter::jsonb)->>'prorows')::float4 = prorows) and (($filter::jsonb)->>'provariadic' is null or (($filter::jsonb)->>'provariadic')::oid = provariadic) and (($filter::jsonb)->>'prosupport' is null or (($filter::jsonb)->>'prosupport')::regproc = prosupport) and (($filter::jsonb)->>'prokind' is null or (($filter::jsonb)->>'prokind')::"char" = prokind) and (($filter::jsonb)->>'prosecdef' is null or (($filter::jsonb)->>'prosecdef')::bool = prosecdef) and (($filter::jsonb)->>'proleakproof' is null or (($filter::jsonb)->>'proleakproof')::bool = proleakproof) and (($filter::jsonb)->>'proisstrict' is null or (($filter::jsonb)->>'proisstrict')::bool = proisstrict) and (($filter::jsonb)->>'proretset' is null or (($filter::jsonb)->>'proretset')::bool = proretset) and (($filter::jsonb)->>'provolatile' is null or (($filter::jsonb)->>'provolatile')::"char" = provolatile) and (($filter::jsonb)->>'proparallel' is null or (($filter::jsonb)->>'proparallel')::"char" = proparallel) and (($filter::jsonb)->>'pronargs' is null or (($filter::jsonb)->>'pronargs')::int2 = pronargs) and (($filter::jsonb)->>'pronargdefaults' is null or (($filter::jsonb)->>'pronargdefaults')::int2 = pronargdefaults) and (($filter::jsonb)->>'prorettype' is null or (($filter::jsonb)->>'prorettype')::oid = prorettype) and (($filter::jsonb)->>'proargtypes' is null or (($filter::jsonb)->>'proargtypes')::oidvector = proargtypes) and (($filter::jsonb)->>'proallargtypes' is null or (($filter::jsonb)->>'proallargtypes')::_oid = proallargtypes) and (($filter::jsonb)->>'proargmodes' is null or (($filter::jsonb)->>'proargmodes')::_char = proargmodes) and (($filter::jsonb)->>'proargnames' is null or (($filter::jsonb)->>'proargnames')::_text = proargnames) and (($filter::jsonb)->>'proargdefaults' is null or (($filter::jsonb)->>'proargdefaults')::pg_node_tree = proargdefaults) and (($filter::jsonb)->>'protrftypes' is null or (($filter::jsonb)->>'protrftypes')::_oid = protrftypes) and (($filter::jsonb)->>'prosrc' is null or (($filter::jsonb)->>'prosrc')::text = prosrc) and (($filter::jsonb)->>'probin' is null or (($filter::jsonb)->>'probin')::text = probin) and (($filter::jsonb)->>'prosqlbody' is null or (($filter::jsonb)->>'prosqlbody')::pg_node_tree = prosqlbody) and (($filter::jsonb)->>'proconfig' is null or (($filter::jsonb)->>'proconfig')::_text = proconfig) and (($filter::jsonb)->>'proacl' is null or (($filter::jsonb)->>'proacl')::_aclitem = proacl))) |
|
|
| 1259 |
pg_catalog |
pg_class |
'**[' || (coalesce(relname::text, '') || ';' || coalesce(relnamespace::text, '')) || ']( ' || '../form/pg_class' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_class
, relname as relname
, relnamespace as relnamespace
, reltype as reltype
, reloftype as reloftype
, relowner as relowner
, relam as relam
, relfilenode as relfilenode
, reltablespace as reltablespace
, relpages as relpages
, reltuples as reltuples
, relallvisible as relallvisible
, relallfrozen as relallfrozen
, reltoastrelid as reltoastrelid
, relhasindex as relhasindex
, relisshared as relisshared
, relpersistence as relpersistence
, relkind as relkind
, relnatts as relnatts
, relchecks as relchecks
, relhasrules as relhasrules
, relhastriggers as relhastriggers
, relhassubclass as relhassubclass
, relrowsecurity as relrowsecurity
, relforcerowsecurity as relforcerowsecurity
, relispopulated as relispopulated
, relreplident as relreplident
, relispartition as relispartition
, relrewrite as relrewrite
, relfrozenxid as relfrozenxid
, relminmxid as relminmxid
, relacl as relacl
, reloptions as reloptions
, relpartbound as relpartbound
|
, 'pg_class' as markdown, 'relname' as markdown, 'relnamespace' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_class' || '=**' || (select coalesce(relname::text, '') || ';' || coalesce(relnamespace::text, '') from pg_class where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'relname' is not null then 'relname' || '=' || (($filter::jsonb)->>'relname') end , case when ($filter::jsonb)->>'relnamespace' is not null then 'relnamespace' || '=' || (($filter::jsonb)->>'relnamespace') end , case when ($filter::jsonb)->>'reltype' is not null then 'reltype' || '=' || (($filter::jsonb)->>'reltype') end , case when ($filter::jsonb)->>'reloftype' is not null then 'reloftype' || '=' || (($filter::jsonb)->>'reloftype') end , case when ($filter::jsonb)->>'relowner' is not null then 'relowner' || '=' || (($filter::jsonb)->>'relowner') end , case when ($filter::jsonb)->>'relam' is not null then 'relam' || '=' || (($filter::jsonb)->>'relam') end , case when ($filter::jsonb)->>'relfilenode' is not null then 'relfilenode' || '=' || (($filter::jsonb)->>'relfilenode') end , case when ($filter::jsonb)->>'reltablespace' is not null then 'reltablespace' || '=' || (($filter::jsonb)->>'reltablespace') end , case when ($filter::jsonb)->>'relpages' is not null then 'relpages' || '=' || (($filter::jsonb)->>'relpages') end , case when ($filter::jsonb)->>'reltuples' is not null then 'reltuples' || '=' || (($filter::jsonb)->>'reltuples') end , case when ($filter::jsonb)->>'relallvisible' is not null then 'relallvisible' || '=' || (($filter::jsonb)->>'relallvisible') end , case when ($filter::jsonb)->>'relallfrozen' is not null then 'relallfrozen' || '=' || (($filter::jsonb)->>'relallfrozen') end , case when ($filter::jsonb)->>'reltoastrelid' is not null then 'reltoastrelid' || '=' || (($filter::jsonb)->>'reltoastrelid') end , case when ($filter::jsonb)->>'relhasindex' is not null then 'relhasindex' || '=' || (($filter::jsonb)->>'relhasindex') end , case when ($filter::jsonb)->>'relisshared' is not null then 'relisshared' || '=' || (($filter::jsonb)->>'relisshared') end , case when ($filter::jsonb)->>'relpersistence' is not null then 'relpersistence' || '=' || (($filter::jsonb)->>'relpersistence') end , case when ($filter::jsonb)->>'relkind' is not null then 'relkind' || '=' || (($filter::jsonb)->>'relkind') end , case when ($filter::jsonb)->>'relnatts' is not null then 'relnatts' || '=' || (($filter::jsonb)->>'relnatts') end , case when ($filter::jsonb)->>'relchecks' is not null then 'relchecks' || '=' || (($filter::jsonb)->>'relchecks') end , case when ($filter::jsonb)->>'relhasrules' is not null then 'relhasrules' || '=' || (($filter::jsonb)->>'relhasrules') end , case when ($filter::jsonb)->>'relhastriggers' is not null then 'relhastriggers' || '=' || (($filter::jsonb)->>'relhastriggers') end , case when ($filter::jsonb)->>'relhassubclass' is not null then 'relhassubclass' || '=' || (($filter::jsonb)->>'relhassubclass') end , case when ($filter::jsonb)->>'relrowsecurity' is not null then 'relrowsecurity' || '=' || (($filter::jsonb)->>'relrowsecurity') end , case when ($filter::jsonb)->>'relforcerowsecurity' is not null then 'relforcerowsecurity' || '=' || (($filter::jsonb)->>'relforcerowsecurity') end , case when ($filter::jsonb)->>'relispopulated' is not null then 'relispopulated' || '=' || (($filter::jsonb)->>'relispopulated') end , case when ($filter::jsonb)->>'relreplident' is not null then 'relreplident' || '=' || (($filter::jsonb)->>'relreplident') end , case when ($filter::jsonb)->>'relispartition' is not null then 'relispartition' || '=' || (($filter::jsonb)->>'relispartition') end , case when ($filter::jsonb)->>'relrewrite' is not null then 'relrewrite' || '=' || (($filter::jsonb)->>'relrewrite') end , case when ($filter::jsonb)->>'relfrozenxid' is not null then 'relfrozenxid' || '=' || (($filter::jsonb)->>'relfrozenxid') end , case when ($filter::jsonb)->>'relminmxid' is not null then 'relminmxid' || '=' || (($filter::jsonb)->>'relminmxid') end , case when ($filter::jsonb)->>'relacl' is not null then 'relacl' || '=' || (($filter::jsonb)->>'relacl') end , case when ($filter::jsonb)->>'reloptions' is not null then 'reloptions' || '=' || (($filter::jsonb)->>'reloptions') end , case when ($filter::jsonb)->>'relpartbound' is not null then 'relpartbound' || '=' || (($filter::jsonb)->>'relpartbound') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'relname' is null or (($filter::jsonb)->>'relname')::name = relname) and (($filter::jsonb)->>'relnamespace' is null or (($filter::jsonb)->>'relnamespace')::oid = relnamespace) and (($filter::jsonb)->>'reltype' is null or (($filter::jsonb)->>'reltype')::oid = reltype) and (($filter::jsonb)->>'reloftype' is null or (($filter::jsonb)->>'reloftype')::oid = reloftype) and (($filter::jsonb)->>'relowner' is null or (($filter::jsonb)->>'relowner')::oid = relowner) and (($filter::jsonb)->>'relam' is null or (($filter::jsonb)->>'relam')::oid = relam) and (($filter::jsonb)->>'relfilenode' is null or (($filter::jsonb)->>'relfilenode')::oid = relfilenode) and (($filter::jsonb)->>'reltablespace' is null or (($filter::jsonb)->>'reltablespace')::oid = reltablespace) and (($filter::jsonb)->>'relpages' is null or (($filter::jsonb)->>'relpages')::int4 = relpages) and (($filter::jsonb)->>'reltuples' is null or (($filter::jsonb)->>'reltuples')::float4 = reltuples) and (($filter::jsonb)->>'relallvisible' is null or (($filter::jsonb)->>'relallvisible')::int4 = relallvisible) and (($filter::jsonb)->>'relallfrozen' is null or (($filter::jsonb)->>'relallfrozen')::int4 = relallfrozen) and (($filter::jsonb)->>'reltoastrelid' is null or (($filter::jsonb)->>'reltoastrelid')::oid = reltoastrelid) and (($filter::jsonb)->>'relhasindex' is null or (($filter::jsonb)->>'relhasindex')::bool = relhasindex) and (($filter::jsonb)->>'relisshared' is null or (($filter::jsonb)->>'relisshared')::bool = relisshared) and (($filter::jsonb)->>'relpersistence' is null or (($filter::jsonb)->>'relpersistence')::"char" = relpersistence) and (($filter::jsonb)->>'relkind' is null or (($filter::jsonb)->>'relkind')::"char" = relkind) and (($filter::jsonb)->>'relnatts' is null or (($filter::jsonb)->>'relnatts')::int2 = relnatts) and (($filter::jsonb)->>'relchecks' is null or (($filter::jsonb)->>'relchecks')::int2 = relchecks) and (($filter::jsonb)->>'relhasrules' is null or (($filter::jsonb)->>'relhasrules')::bool = relhasrules) and (($filter::jsonb)->>'relhastriggers' is null or (($filter::jsonb)->>'relhastriggers')::bool = relhastriggers) and (($filter::jsonb)->>'relhassubclass' is null or (($filter::jsonb)->>'relhassubclass')::bool = relhassubclass) and (($filter::jsonb)->>'relrowsecurity' is null or (($filter::jsonb)->>'relrowsecurity')::bool = relrowsecurity) and (($filter::jsonb)->>'relforcerowsecurity' is null or (($filter::jsonb)->>'relforcerowsecurity')::bool = relforcerowsecurity) and (($filter::jsonb)->>'relispopulated' is null or (($filter::jsonb)->>'relispopulated')::bool = relispopulated) and (($filter::jsonb)->>'relreplident' is null or (($filter::jsonb)->>'relreplident')::"char" = relreplident) and (($filter::jsonb)->>'relispartition' is null or (($filter::jsonb)->>'relispartition')::bool = relispartition) and (($filter::jsonb)->>'relrewrite' is null or (($filter::jsonb)->>'relrewrite')::oid = relrewrite) and (($filter::jsonb)->>'relfrozenxid' is null or (($filter::jsonb)->>'relfrozenxid')::xid = relfrozenxid) and (($filter::jsonb)->>'relminmxid' is null or (($filter::jsonb)->>'relminmxid')::xid = relminmxid) and (($filter::jsonb)->>'relacl' is null or (($filter::jsonb)->>'relacl')::_aclitem = relacl) and (($filter::jsonb)->>'reloptions' is null or (($filter::jsonb)->>'reloptions')::_text = reloptions) and (($filter::jsonb)->>'relpartbound' is null or (($filter::jsonb)->>'relpartbound')::pg_node_tree = relpartbound))) |
|
|
| 1260 |
pg_catalog |
pg_authid |
'**[' || (coalesce(rolname::text, '')) || ']( ' || '../form/pg_authid' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_authid
, rolname as rolname
, rolsuper as rolsuper
, rolinherit as rolinherit
, rolcreaterole as rolcreaterole
, rolcreatedb as rolcreatedb
, rolcanlogin as rolcanlogin
, rolreplication as rolreplication
, rolbypassrls as rolbypassrls
, rolconnlimit as rolconnlimit
, rolpassword as rolpassword
, rolvaliduntil as rolvaliduntil
|
, 'pg_authid' as markdown, 'rolname' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_authid' || '=**' || (select coalesce(rolname::text, '') from pg_authid where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'rolname' is not null then 'rolname' || '=' || (($filter::jsonb)->>'rolname') end , case when ($filter::jsonb)->>'rolsuper' is not null then 'rolsuper' || '=' || (($filter::jsonb)->>'rolsuper') end , case when ($filter::jsonb)->>'rolinherit' is not null then 'rolinherit' || '=' || (($filter::jsonb)->>'rolinherit') end , case when ($filter::jsonb)->>'rolcreaterole' is not null then 'rolcreaterole' || '=' || (($filter::jsonb)->>'rolcreaterole') end , case when ($filter::jsonb)->>'rolcreatedb' is not null then 'rolcreatedb' || '=' || (($filter::jsonb)->>'rolcreatedb') end , case when ($filter::jsonb)->>'rolcanlogin' is not null then 'rolcanlogin' || '=' || (($filter::jsonb)->>'rolcanlogin') end , case when ($filter::jsonb)->>'rolreplication' is not null then 'rolreplication' || '=' || (($filter::jsonb)->>'rolreplication') end , case when ($filter::jsonb)->>'rolbypassrls' is not null then 'rolbypassrls' || '=' || (($filter::jsonb)->>'rolbypassrls') end , case when ($filter::jsonb)->>'rolconnlimit' is not null then 'rolconnlimit' || '=' || (($filter::jsonb)->>'rolconnlimit') end , case when ($filter::jsonb)->>'rolpassword' is not null then 'rolpassword' || '=' || (($filter::jsonb)->>'rolpassword') end , case when ($filter::jsonb)->>'rolvaliduntil' is not null then 'rolvaliduntil' || '=' || (($filter::jsonb)->>'rolvaliduntil') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'rolname' is null or (($filter::jsonb)->>'rolname')::name = rolname) and (($filter::jsonb)->>'rolsuper' is null or (($filter::jsonb)->>'rolsuper')::bool = rolsuper) and (($filter::jsonb)->>'rolinherit' is null or (($filter::jsonb)->>'rolinherit')::bool = rolinherit) and (($filter::jsonb)->>'rolcreaterole' is null or (($filter::jsonb)->>'rolcreaterole')::bool = rolcreaterole) and (($filter::jsonb)->>'rolcreatedb' is null or (($filter::jsonb)->>'rolcreatedb')::bool = rolcreatedb) and (($filter::jsonb)->>'rolcanlogin' is null or (($filter::jsonb)->>'rolcanlogin')::bool = rolcanlogin) and (($filter::jsonb)->>'rolreplication' is null or (($filter::jsonb)->>'rolreplication')::bool = rolreplication) and (($filter::jsonb)->>'rolbypassrls' is null or (($filter::jsonb)->>'rolbypassrls')::bool = rolbypassrls) and (($filter::jsonb)->>'rolconnlimit' is null or (($filter::jsonb)->>'rolconnlimit')::int4 = rolconnlimit) and (($filter::jsonb)->>'rolpassword' is null or (($filter::jsonb)->>'rolpassword')::text = rolpassword) and (($filter::jsonb)->>'rolvaliduntil' is null or (($filter::jsonb)->>'rolvaliduntil')::timestamptz = rolvaliduntil))) |
|
|
| 1261 |
pg_catalog |
pg_auth_members |
'**[' || (coalesce(roleid::text, '') || ';' || coalesce(member::text, '') || ';' || coalesce(grantor::text, '')) || ']( ' || '../form/pg_auth_members' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_auth_members
, roleid as roleid
, member as member
, grantor as grantor
, admin_option as admin_option
, inherit_option as inherit_option
, set_option as set_option
|
, 'pg_auth_members' as markdown, 'roleid' as markdown, 'member' as markdown, 'grantor' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_auth_members' || '=**' || (select coalesce(roleid::text, '') || ';' || coalesce(member::text, '') || ';' || coalesce(grantor::text, '') from pg_auth_members where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'roleid' is not null then 'roleid' || '=' || (($filter::jsonb)->>'roleid') end , case when ($filter::jsonb)->>'member' is not null then 'member' || '=' || (($filter::jsonb)->>'member') end , case when ($filter::jsonb)->>'grantor' is not null then 'grantor' || '=' || (($filter::jsonb)->>'grantor') end , case when ($filter::jsonb)->>'admin_option' is not null then 'admin_option' || '=' || (($filter::jsonb)->>'admin_option') end , case when ($filter::jsonb)->>'inherit_option' is not null then 'inherit_option' || '=' || (($filter::jsonb)->>'inherit_option') end , case when ($filter::jsonb)->>'set_option' is not null then 'set_option' || '=' || (($filter::jsonb)->>'set_option') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'roleid' is null or (($filter::jsonb)->>'roleid')::oid = roleid) and (($filter::jsonb)->>'member' is null or (($filter::jsonb)->>'member')::oid = member) and (($filter::jsonb)->>'grantor' is null or (($filter::jsonb)->>'grantor')::oid = grantor) and (($filter::jsonb)->>'admin_option' is null or (($filter::jsonb)->>'admin_option')::bool = admin_option) and (($filter::jsonb)->>'inherit_option' is null or (($filter::jsonb)->>'inherit_option')::bool = inherit_option) and (($filter::jsonb)->>'set_option' is null or (($filter::jsonb)->>'set_option')::bool = set_option))) |
|
|
| 1262 |
pg_catalog |
pg_database |
'**[' || (coalesce(datname::text, '')) || ']( ' || '../form/pg_database' || dwui.jsonb_urlencode(sqlpage.variables('get'), ('{"id": ' || to_json(oid::text) || '}')::jsonb ) || ')**' as pg_database
, datname as datname
, datdba as datdba
, encoding as encoding
, datlocprovider as datlocprovider
, datistemplate as datistemplate
, datallowconn as datallowconn
, dathasloginevt as dathasloginevt
, datconnlimit as datconnlimit
, datfrozenxid as datfrozenxid
, datminmxid as datminmxid
, dattablespace as dattablespace
, datcollate as datcollate
, datctype as datctype
, datlocale as datlocale
, daticurules as daticurules
, datcollversion as datcollversion
, datacl as datacl
|
, 'pg_database' as markdown, 'datname' as markdown |
oid |
oid |
case when $filter is not null then ' filter is: ' end || concat(case when ($filter::jsonb)->>'oid' is not null then 'pg_database' || '=**' || (select coalesce(datname::text, '') from pg_database where (($filter::jsonb)->>'oid')::oid = oid) || '**' end , case when ($filter::jsonb)->>'datname' is not null then 'datname' || '=' || (($filter::jsonb)->>'datname') end , case when ($filter::jsonb)->>'datdba' is not null then 'datdba' || '=' || (($filter::jsonb)->>'datdba') end , case when ($filter::jsonb)->>'encoding' is not null then 'encoding' || '=' || (($filter::jsonb)->>'encoding') end , case when ($filter::jsonb)->>'datlocprovider' is not null then 'datlocprovider' || '=' || (($filter::jsonb)->>'datlocprovider') end , case when ($filter::jsonb)->>'datistemplate' is not null then 'datistemplate' || '=' || (($filter::jsonb)->>'datistemplate') end , case when ($filter::jsonb)->>'datallowconn' is not null then 'datallowconn' || '=' || (($filter::jsonb)->>'datallowconn') end , case when ($filter::jsonb)->>'dathasloginevt' is not null then 'dathasloginevt' || '=' || (($filter::jsonb)->>'dathasloginevt') end , case when ($filter::jsonb)->>'datconnlimit' is not null then 'datconnlimit' || '=' || (($filter::jsonb)->>'datconnlimit') end , case when ($filter::jsonb)->>'datfrozenxid' is not null then 'datfrozenxid' || '=' || (($filter::jsonb)->>'datfrozenxid') end , case when ($filter::jsonb)->>'datminmxid' is not null then 'datminmxid' || '=' || (($filter::jsonb)->>'datminmxid') end , case when ($filter::jsonb)->>'dattablespace' is not null then 'dattablespace' || '=' || (($filter::jsonb)->>'dattablespace') end , case when ($filter::jsonb)->>'datcollate' is not null then 'datcollate' || '=' || (($filter::jsonb)->>'datcollate') end , case when ($filter::jsonb)->>'datctype' is not null then 'datctype' || '=' || (($filter::jsonb)->>'datctype') end , case when ($filter::jsonb)->>'datlocale' is not null then 'datlocale' || '=' || (($filter::jsonb)->>'datlocale') end , case when ($filter::jsonb)->>'daticurules' is not null then 'daticurules' || '=' || (($filter::jsonb)->>'daticurules') end , case when ($filter::jsonb)->>'datcollversion' is not null then 'datcollversion' || '=' || (($filter::jsonb)->>'datcollversion') end , case when ($filter::jsonb)->>'datacl' is not null then 'datacl' || '=' || (($filter::jsonb)->>'datacl') end ) |
($filter is null or ((($filter::jsonb)->>'oid' is null or (($filter::jsonb)->>'oid')::oid = oid) and (($filter::jsonb)->>'datname' is null or (($filter::jsonb)->>'datname')::name = datname) and (($filter::jsonb)->>'datdba' is null or (($filter::jsonb)->>'datdba')::oid = datdba) and (($filter::jsonb)->>'encoding' is null or (($filter::jsonb)->>'encoding')::int4 = encoding) and (($filter::jsonb)->>'datlocprovider' is null or (($filter::jsonb)->>'datlocprovider')::"char" = datlocprovider) and (($filter::jsonb)->>'datistemplate' is null or (($filter::jsonb)->>'datistemplate')::bool = datistemplate) and (($filter::jsonb)->>'datallowconn' is null or (($filter::jsonb)->>'datallowconn')::bool = datallowconn) and (($filter::jsonb)->>'dathasloginevt' is null or (($filter::jsonb)->>'dathasloginevt')::bool = dathasloginevt) and (($filter::jsonb)->>'datconnlimit' is null or (($filter::jsonb)->>'datconnlimit')::int4 = datconnlimit) and (($filter::jsonb)->>'datfrozenxid' is null or (($filter::jsonb)->>'datfrozenxid')::xid = datfrozenxid) and (($filter::jsonb)->>'datminmxid' is null or (($filter::jsonb)->>'datminmxid')::xid = datminmxid) and (($filter::jsonb)->>'dattablespace' is null or (($filter::jsonb)->>'dattablespace')::oid = dattablespace) and (($filter::jsonb)->>'datcollate' is null or (($filter::jsonb)->>'datcollate')::text = datcollate) and (($filter::jsonb)->>'datctype' is null or (($filter::jsonb)->>'datctype')::text = datctype) and (($filter::jsonb)->>'datlocale' is null or (($filter::jsonb)->>'datlocale')::text = datlocale) and (($filter::jsonb)->>'daticurules' is null or (($filter::jsonb)->>'daticurules')::text = daticurules) and (($filter::jsonb)->>'datcollversion' is null or (($filter::jsonb)->>'datcollversion')::text = datcollversion) and (($filter::jsonb)->>'datacl' is null or (($filter::jsonb)->>'datacl')::_aclitem = datacl))) |
|
|