Welcome to db-deps’s documentation!¶
The db-deps project provides functions for use in PostgreSQL projects with dynamically managed database objects. Specifically, it provides a means to edit database objects that require dropping and recreating of dependent objects, without manually defining the statements for this dependent object dropping and recreating.
Contents:
dep_recurse¶
Tables¶
Functions¶
| Name | Return Type | Description |
|---|---|---|
| alter(obj dep_recurse.obj_ref, changes character varying[], exclude dep_recurse.obj_ref[]) | dep_recurse.obj_ref | |
| alter(obj dep_recurse.obj_ref, changes character varying[]) | dep_recurse.obj_ref | |
| comment_column_statements(oid) | SETOF character varying | |
| comment_view_statement(oid) | character varying | |
| create_materialized_view_statement(obj_schema name, obj_name name) | character varying | |
| create_view_statement(oid) | character varying | |
| creation_statements(dep_recurse.obj_ref) | SETOF character varying | |
| dependent_create_statements(dep_recurse.obj_ref, exclude dep_recurse.obj_ref[]) | SETOF character varying | |
| dependent_create_statements(dep_recurse.obj_ref) | SETOF character varying | |
| dependent_drop_statements(dep_recurse.obj_ref, exclude dep_recurse.obj_ref[]) | SETOF character varying | |
| dependent_drop_statements(dep_recurse.obj_ref) | SETOF character varying | |
| deps(dep_recurse.obj_ref) | SETOF dep_recurse.dep | |
| direct_deps(dep_recurse.obj_ref) | SETOF dep_recurse.obj_ref | |
| direct_function_deps(oid) | SETOF dep_recurse.obj_ref | |
| direct_function_relation_deps(obj_schema name, obj_name name) | SETOF dep_recurse.obj_ref | return set of functions that are directly dependent on the relation with name obj_name in schema obj_schema |
| direct_function_relation_deps(oid) | SETOF dep_recurse.obj_ref | return set of functions that are directly dependent on the relation with id oid |
| direct_relation_deps(oid) | SETOF dep_recurse.obj_ref | return set of references to objects that are directly dependent on the relation (pg_class) oid |
| direct_table_relation_deps(oid) | SETOF dep_recurse.obj_ref | |
| direct_view_relation_deps(obj_schema name, obj_name name) | SETOF dep_recurse.obj_ref | return set of views that are directly dependent on the relation with name obj_name in schema obj_schema |
| direct_view_relation_deps(oid) | SETOF dep_recurse.obj_ref | |
| drop_statement(dep_recurse.obj_ref) | character varying | |
| execute(statements character varying[]) | void | execute a set of schema altering queries |
| function_creation_statements(oid) | SETOF character varying | |
| function_drop_statement(oid) | character varying | |
| function_ref(oid) | dep_recurse.obj_ref | |
| function_ref(obj_schema name, obj_name name, signature text[]) | dep_recurse.obj_ref | |
| function_signature(oid) | text[] | |
| function_signature_str(oid) | text | |
| function_to_char(oid) | text | |
| grant_function_statements(oid) | SETOF character varying | |
| grant_view_statements(oid) | SETOF character varying | |
| materialized_view_drop_statement(oid) | SETOF character varying | |
| owner_function_statement(oid) | character varying | |
| owner_view_statement(oid) | text | |
| raise_exception(anyelement, text) | anyelement | |
| table_ref(oid) | dep_recurse.obj_ref | |
| table_ref(obj_schema name, obj_name name) | dep_recurse.obj_ref | |
| table_to_char(oid) | text | |
| to_char(dep_recurse.obj_ref) | text | |
| to_char(dep_recurse.dep) | text | |
| to_oid(dep_recurse.obj_ref) | oid | |
| type_to_char(oid) | text | |
| view_creation_statements(oid) | SETOF character varying | |
| view_drop_statement(oid) | SETOF character varying | |
| view_ref(obj_schema name, obj_name name) | dep_recurse.obj_ref | |
| view_ref(oid) | dep_recurse.obj_ref | |
| view_to_char(oid) | text |