Last active
May 30, 2022 12:52
-
-
Save SKalt/da4951ef72b96e6a954d4fe1cbcda338 to your computer and use it in GitHub Desktop.
pg object class dependencies research
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dependent | dependency | label | notes | citation | |
|---|---|---|---|---|---|
| access function | method | handler_function | https://www.postgresql.org/docs/current/sql-create-access-method.html | ||
| aggregate | function | https://www.postgresql.org/docs/current/sql-createaggregate.html | |||
| aggregate | operator | https://www.postgresql.org/docs/current/sql-createaggregate.html | |||
| aggregate | schema | https://www.postgresql.org/docs/current/sql-createaggregate.html | |||
| aggregate | type | arg_data_type | An input data type on which this aggregate function operates. | https://www.postgresql.org/docs/current/sql-createaggregate.html | |
| aggregate | type | base_type | https://www.postgresql.org/docs/current/sql-createaggregate.html | ||
| aggregate | type | state_data_type | https://www.postgresql.org/docs/current/sql-createaggregate.html | ||
| cast | function | https://www.postgresql.org/docs/current/sql-createcast.html | |||
| cast | type | {source,target}_type | https://www.postgresql.org/docs/current/sql-createcast.html | ||
| collation | type | for range types or composite types | https://www.postgresql.org/docs/current/sql-createtype.html | ||
| column | collation | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| column | foreign table | https://www.postgresql.org/docs/current/sql-createforeigntable.html | |||
| column | table | column_name | https://www.postgresql.org/docs/current/sql-createtable.html | ||
| column | type | data_type | https://www.postgresql.org/docs/current/sql-createtable.html | ||
| constraint | column | column_constraint | https://www.postgresql.org/docs/current/sql-createtable.html | ||
| constraint | domain | https://www.postgresql.org/docs/current/sql-createdomain.html | |||
| constraint | expr | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| constraint | foreign table | https://www.postgresql.org/docs/current/sql-createforeigntable.html | |||
| constraint | index | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| conversion | encoding | {source,dest}_encoding | https://www.postgresql.org/docs/current/sql-createconversion.html | ||
| conversion | function | function_name | https://www.postgresql.org/docs/current/sql-createconversion.html | ||
| conversion | schema | https://www.postgresql.org/docs/current/sql-createconversion.html | |||
| database | database | template | https://www.postgresql.org/docs/current/sql-createdatabase.html | ||
| database | encoding | https://www.postgresql.org/docs/current/sql-createdatabase.html | |||
| database | role | owner | https://www.postgresql.org/docs/current/sql-createdatabase.html | ||
| domain | collation | https://www.postgresql.org/docs/current/sql-createdomain.html | |||
| domain | expr | https://www.postgresql.org/docs/current/sql-createdomain.html | |||
| event trigger | function | https://www.postgresql.org/docs/current/sql-createeventtrigger.html | |||
| extension | schema | https://www.postgresql.org/docs/current/sql-createextension.html | |||
| foreign data wrapper | function | handler_function | called to retrieve the execution functions for foreign tables | https://www.postgresql.org/docs/current/sql-createforeigndatawrapper.html | |
| foreign data wrapper | function | validator_function | called to check the generic options given to the foreign-data wrapper | https://www.postgresql.org/docs/current/sql-createforeigndatawrapper.html | |
| foreign table | foreign table | parent | https://www.postgresql.org/docs/current/sql-createforeigntable.html | ||
| foreign table | schema | table_name | https://www.postgresql.org/docs/current/sql-createforeigntable.html | ||
| foreign table | server | https://www.postgresql.org/docs/current/sql-createforeigntable.html | |||
| function | function | support_function | https://www.postgresql.org/docs/current/sql-createfunction.html | ||
| function | language | lang_name | https://www.postgresql.org/docs/current/sql-createfunction.html | ||
| function | schema | https://www.postgresql.org/docs/current/sql-createfunction.html | |||
| function | type | argtype | https://www.postgresql.org/docs/current/sql-createfunction.html | ||
| function | type | rettype | https://www.postgresql.org/docs/current/sql-createfunction.html | ||
| generated column | expr | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| index | collation | collate | https://www.postgresql.org/docs/current/sql-createindex.html | ||
| index | column | index a column | https://www.postgresql.org/docs/current/sql-createindex.html | ||
| index | column | include | include a column for index-only scans | https://www.postgresql.org/docs/current/sql-createindex.html | |
| index | expr | expression on column, like lower(text_case) | https://www.postgresql.org/docs/current/sql-createindex.html | ||
| index | expr | predicate | https://www.postgresql.org/docs/current/sql-createindex.html | ||
| index | opclass | https://www.postgresql.org/docs/current/sql-createindex.html | |||
| index | table | table_name | the table on which the index operates | https://www.postgresql.org/docs/current/sql-createindex.html | |
| index | tablespace | https://www.postgresql.org/docs/current/sql-createindex.html | |||
| language | function | call_handler | requires dynamic linking | https://www.postgresql.org/docs/current/sql-createlanguage.html | |
| materialized view | access method | https://www.postgresql.org/docs/current/sql-creatematerializedview.html | |||
| materialized view | expr | query | https://www.postgresql.org/docs/current/sql-creatematerializedview.html | ||
| materialized view | schema | https://www.postgresql.org/docs/current/sql-creatematerializedview.html | |||
| materialized view | tablespace | https://www.postgresql.org/docs/current/sql-creatematerializedview.html | |||
| opclass | function | function_name | https://www.postgresql.org/docs/current/sql-createopclass.html | ||
| opclass | operator | operator_name | The name (optionally schema-qualified) of an operator associated with the operator class. | https://www.postgresql.org/docs/current/sql-createopclass.html | |
| opclass | opfamily | family_name | https://www.postgresql.org/docs/current/sql-createopclass.html | ||
| opclass | schema | https://www.postgresql.org/docs/current/sql-createopclass.html | |||
| opclass | type | argument_type | https://www.postgresql.org/docs/current/sql-createopclass.html | ||
| opclass | type | data_type | https://www.postgresql.org/docs/current/sql-createopclass.html | ||
| opclass | type | op_type | https://www.postgresql.org/docs/current/sql-createopclass.html | ||
| operator | function | {res,join}_proc | https://www.postgresql.org/docs/current/sql-createoperator.html | ||
| operator | function | function_name | https://www.postgresql.org/docs/current/sql-createoperator.html | ||
| operator | operator | {com,neg}_op | https://www.postgresql.org/docs/current/sql-createoperator.html | ||
| operator | type | {left,right}_type | https://www.postgresql.org/docs/current/sql-createoperator.html | ||
| operator family | access method | index_method | https://www.postgresql.org/docs/current/sql-createopfamily.html | ||
| operator family | schema | https://www.postgresql.org/docs/current/sql-createopfamily.html | |||
| partition | collation | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| partition | column | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| partition | expr | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| partition | opclass | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| partition | partition | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| partition | table | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| policy | expr | {using,check}_expression | https://www.postgresql.org/docs/current/sql-createdomain.html | ||
| policy | role | role_name | https://www.postgresql.org/docs/current/sql-createdomain.html | ||
| policy | table | table_name | https://www.postgresql.org/docs/current/sql-createdomain.html | ||
| publication | table | table_name | https://www.postgresql.org/docs/current/sql-createpublication.html | ||
| rule | expr | condition | https://www.postgresql.org/docs/current/sql-createrule.html | ||
| rule | table | https://www.postgresql.org/docs/current/sql-createrule.html | |||
| schema | role | https://www.postgresql.org/docs/current/sql-createschema.html | |||
| sequence | column | https://www.postgresql.org/docs/current/sql-createsequence.html | |||
| sequence | type | data_type | https://www.postgresql.org/docs/current/sql-createsequence.html | ||
| server | foreign data wrapper | fdw_name | https://www.postgresql.org/docs/current/sql-createserver.html | ||
| statistics | column | https://www.postgresql.org/docs/current/sql-createstatistics.html | |||
| statistics | expr | https://www.postgresql.org/docs/current/sql-createstatistics.html | |||
| statistics | schema | https://www.postgresql.org/docs/current/sql-createstatistics.html | |||
| statistics | table | https://www.postgresql.org/docs/current/sql-createstatistics.html | |||
| subscription | publication | https://www.postgresql.org/docs/current/sql-createsubscription.html | |||
| table | access method | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| table | schema | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| table | table | parent_table | https://www.postgresql.org/docs/current/sql-createtable.html | ||
| table | tablespace | https://www.postgresql.org/docs/current/sql-createtable.html | |||
| table | type | type_name | Creates a typed table, which takes its structure from the specified composite type | https://www.postgresql.org/docs/current/sql-createtable.html | |
| transform | function | https://www.postgresql.org/docs/current/sql-createtransform.html | |||
| trigger | expr | condition | https://www.postgresql.org/docs/current/sql-createtrigger.html | ||
| trigger | function | {to,from}_sql_function_name | https://www.postgresql.org/docs/current/sql-createtrigger.html | ||
| trigger | table | table_name | https://www.postgresql.org/docs/current/sql-createtrigger.html | ||
| tsconfig | schema | https://www.postgresql.org/docs/current/sql-createtsconfig.html | |||
| tsconfig | tsconfig | source_config | https://www.postgresql.org/docs/current/sql-createtsconfig.html | ||
| tsconfig | tsparser | https://www.postgresql.org/docs/current/sql-createtsconfig.html | |||
| tsdict | schema | https://www.postgresql.org/docs/current/sql-createtsdictionary.html | |||
| tsdict | tstemplate | https://www.postgresql.org/docs/current/sql-createtsdictionary.html | |||
| tsparser | function | {start,getttoken,end,lextypes,headline}_function | https://www.postgresql.org/docs/current/sql-createtsparser.html | ||
| tsparser | schema | https://www.postgresql.org/docs/current/sql-createtsparser.html | |||
| tstemplate | function | init_function | https://www.postgresql.org/docs/current/sql-createtstemplate.html | ||
| tstemplate | function | lexize_function | https://www.postgresql.org/docs/current/sql-createtstemplate.html | ||
| tstemplate | schema | https://www.postgresql.org/docs/current/sql-createtstemplate.html | |||
| type | function | analyze_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | canonical_function | for range types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | input_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | output_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | receive_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | send_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | subscript_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | subtype_diff | for range types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | type_modifier_input_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | function | type_modifier_output_function | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | opclass | subtype_operator_class | https://www.postgresql.org/docs/current/sql-createtype.html | ||
| type | type | data_type | for composite types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | type | like_type | for base types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| type | type | subtype | for range types | https://www.postgresql.org/docs/current/sql-createtype.html | |
| user mapping | role | user_name | https://www.postgresql.org/docs/current/sql-createusermapping.html | ||
| user mapping | server | server_name | https://www.postgresql.org/docs/current/sql-createusermapping.html | ||
| view | expr | query | https://www.postgresql.org/docs/current/sql-createview.html | ||
| view | schema | https://www.postgresql.org/docs/current/sql-createview.html |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment