evergreen.tap_funky (view)

↑ evergreen schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

oid

oid

Yes

schema

name

Yes

name

name

Yes

owner

name

Yes

args

text

Yes

returns

text

Yes

langoid

oid

Yes

is_strict

boolean

Yes

kind

"char"

Yes

is_definer

boolean

Yes

returns_set

boolean

Yes

volatility

character(1)

Yes

is_visible

boolean

Yes

View Definition

 SELECT p.oid,
    n.nspname AS schema,
    p.proname AS name,
    pg_get_userbyid(p.proowner) AS owner,
    array_to_string(p.proargtypes::regtype[], ','::text) AS args,
        CASE p.proretset
            WHEN true THEN 'setof '::text
            ELSE ''::text
        END || p.prorettype::regtype AS returns,
    p.prolang AS langoid,
    p.proisstrict AS is_strict,
    _prokind(p.oid) AS kind,
    p.prosecdef AS is_definer,
    p.proretset AS returns_set,
    p.provolatile::character(1) AS volatility,
    pg_function_is_visible(p.oid) AS is_visible
   FROM pg_proc p
     JOIN pg_namespace n ON p.pronamespace = n.oid;
Previous
Next