{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Overview of Pre-Defined Functions\n", "\n", "Like any RDBMS, Postgres provides robust set of pre-defined functions to come up with solutions quickly as per the business requirements. There are many functions, but we will see the most common ones here." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "tags": [ "remove-cell" ] }, "outputs": [ { "data": { "text/html": [ "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "%%HTML\n", "" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "* Following are the categories of functions that are more commonly used.\n", " * String Manipulation\n", " * Date Manipulation\n", " * Numeric Functions\n", " * Type Conversion Functions\n", " * CASE and WHEN\n", " * and more\n", "* One can go to the official documentation from [Postgres website](https://www.postgresql.org/)." ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "%load_ext sql" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "env: DATABASE_URL=postgresql://itversity_retail_user:retail_password@localhost:5432/itversity_retail_db\n" ] } ], "source": [ "%env DATABASE_URL=postgresql://itversity_retail_user:retail_password@localhost:5432/itversity_retail_db" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "10 rows affected.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
specific_catalogspecific_schemaspecific_nameroutine_catalogroutine_schemaroutine_nameroutine_typemodule_catalogmodule_schemamodule_nameudt_catalogudt_schemaudt_namedata_typecharacter_maximum_lengthcharacter_octet_lengthcharacter_set_catalogcharacter_set_schemacharacter_set_namecollation_catalogcollation_schemacollation_namenumeric_precisionnumeric_precision_radixnumeric_scaledatetime_precisioninterval_typeinterval_precisiontype_udt_catalogtype_udt_schematype_udt_namescope_catalogscope_schemascope_namemaximum_cardinalitydtd_identifierroutine_bodyroutine_definitionexternal_nameexternal_languageparameter_styleis_deterministicsql_data_accessis_null_callsql_pathschema_level_routinemax_dynamic_result_setsis_user_defined_castis_implicitly_invocablesecurity_typeto_sql_specific_catalogto_sql_specific_schemato_sql_specific_nameas_locatorcreatedlast_alterednew_savepoint_levelis_udt_dependentresult_cast_from_data_typeresult_cast_as_locatorresult_cast_char_max_lengthresult_cast_char_octet_lengthresult_cast_char_set_catalogresult_cast_char_set_schemaresult_cast_char_set_nameresult_cast_collation_catalogresult_cast_collation_schemaresult_cast_collation_nameresult_cast_numeric_precisionresult_cast_numeric_precision_radixresult_cast_numeric_scaleresult_cast_datetime_precisionresult_cast_interval_typeresult_cast_interval_precisionresult_cast_type_udt_catalogresult_cast_type_udt_schemaresult_cast_type_udt_nameresult_cast_scope_catalogresult_cast_scope_schemaresult_cast_scope_nameresult_cast_maximum_cardinalityresult_cast_dtd_identifier
itversity_retail_dbpg_catalogboolin_1242itversity_retail_dbpg_catalogboolinFUNCTIONNoneNoneNoneNoneNoneNonebooleanNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogboolNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogboolout_1243itversity_retail_dbpg_catalogbooloutFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogbyteain_1244itversity_retail_dbpg_catalogbyteainFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogbyteaout_31itversity_retail_dbpg_catalogbyteaoutFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogcharin_1245itversity_retail_dbpg_catalogcharinFUNCTIONNoneNoneNoneNoneNoneNone"char"NoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcharNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogcharout_33itversity_retail_dbpg_catalogcharoutFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalognamein_34itversity_retail_dbpg_catalognameinFUNCTIONNoneNoneNoneNoneNoneNonenameNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalognameNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalognameout_35itversity_retail_dbpg_catalognameoutFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogint2in_38itversity_retail_dbpg_catalogint2inFUNCTIONNoneNoneNoneNoneNoneNonesmallintNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogint2NoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogint2out_39itversity_retail_dbpg_catalogint2outFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
" ], "text/plain": [ "[('itversity_retail_db', 'pg_catalog', 'boolin_1242', 'itversity_retail_db', 'pg_catalog', 'boolin', 'FUNCTION', None, None, None, None, None, None, 'boolean', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bool', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'boolout_1243', 'itversity_retail_db', 'pg_catalog', 'boolout', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'byteain_1244', 'itversity_retail_db', 'pg_catalog', 'byteain', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'byteaout_31', 'itversity_retail_db', 'pg_catalog', 'byteaout', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'charin_1245', 'itversity_retail_db', 'pg_catalog', 'charin', 'FUNCTION', None, None, None, None, None, None, '\"char\"', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'char', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'charout_33', 'itversity_retail_db', 'pg_catalog', 'charout', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'namein_34', 'itversity_retail_db', 'pg_catalog', 'namein', 'FUNCTION', None, None, None, None, None, None, 'name', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'name', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'nameout_35', 'itversity_retail_db', 'pg_catalog', 'nameout', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'int2in_38', 'itversity_retail_db', 'pg_catalog', 'int2in', 'FUNCTION', None, None, None, None, None, None, 'smallint', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'int2', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'int2out_39', 'itversity_retail_db', 'pg_catalog', 'int2out', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None)]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql SELECT * FROM information_schema.routines LIMIT 10" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * postgresql://itversity_retail_user:***@localhost:5432/itversity_retail_db\n", "36 rows affected.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
specific_catalogspecific_schemaspecific_nameroutine_catalogroutine_schemaroutine_nameroutine_typemodule_catalogmodule_schemamodule_nameudt_catalogudt_schemaudt_namedata_typecharacter_maximum_lengthcharacter_octet_lengthcharacter_set_catalogcharacter_set_schemacharacter_set_namecollation_catalogcollation_schemacollation_namenumeric_precisionnumeric_precision_radixnumeric_scaledatetime_precisioninterval_typeinterval_precisiontype_udt_catalogtype_udt_schematype_udt_namescope_catalogscope_schemascope_namemaximum_cardinalitydtd_identifierroutine_bodyroutine_definitionexternal_nameexternal_languageparameter_styleis_deterministicsql_data_accessis_null_callsql_pathschema_level_routinemax_dynamic_result_setsis_user_defined_castis_implicitly_invocablesecurity_typeto_sql_specific_catalogto_sql_specific_schemato_sql_specific_nameas_locatorcreatedlast_alterednew_savepoint_levelis_udt_dependentresult_cast_from_data_typeresult_cast_as_locatorresult_cast_char_max_lengthresult_cast_char_octet_lengthresult_cast_char_set_catalogresult_cast_char_set_schemaresult_cast_char_set_nameresult_cast_collation_catalogresult_cast_collation_schemaresult_cast_collation_nameresult_cast_numeric_precisionresult_cast_numeric_precision_radixresult_cast_numeric_scaleresult_cast_datetime_precisionresult_cast_interval_typeresult_cast_interval_precisionresult_cast_type_udt_catalogresult_cast_type_udt_schemaresult_cast_type_udt_nameresult_cast_scope_catalogresult_cast_scope_schemaresult_cast_scope_nameresult_cast_maximum_cardinalityresult_cast_dtd_identifier
itversity_retail_dbpg_catalogbtvarstrequalimage_5050itversity_retail_dbpg_catalogbtvarstrequalimageFUNCTIONNoneNoneNoneNoneNoneNonebooleanNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogboolNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstring_to_array_394itversity_retail_dbpg_catalogstring_to_arrayFUNCTIONNoneNoneNoneNoneNoneNoneARRAYNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalog_textNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogarray_to_string_395itversity_retail_dbpg_catalogarray_to_stringFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstring_to_array_376itversity_retail_dbpg_catalogstring_to_arrayFUNCTIONNoneNoneNoneNoneNoneNoneARRAYNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalog_textNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogarray_to_string_384itversity_retail_dbpg_catalogarray_to_stringFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstrpos_868itversity_retail_dbpg_catalogstrposFUNCTIONNoneNoneNoneNoneNoneNoneintegerNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogint4NoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstr_877itversity_retail_dbpg_catalogsubstrFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstr_883itversity_retail_dbpg_catalogsubstrFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_936itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_937itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogpg_get_partition_constraintdef_3408itversity_retail_dbpg_catalogpg_get_partition_constraintdefFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogpg_get_constraintdef_1387itversity_retail_dbpg_catalogpg_get_constraintdefFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogRI_FKey_restrict_del_1648itversity_retail_dbpg_catalogRI_FKey_restrict_delFUNCTIONNoneNoneNoneNoneNoneNonetriggerNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtriggerNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogRI_FKey_restrict_upd_1649itversity_retail_dbpg_catalogRI_FKey_restrict_updFUNCTIONNoneNoneNoneNoneNoneNonetriggerNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtriggerNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_1680itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonebitNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbitNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_1699itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonebitNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbitNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstring_agg_transfn_3535itversity_retail_dbpg_catalogstring_agg_transfnFUNCTIONNoneNoneNoneNoneNoneNoneinternalNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_cataloginternalNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstring_agg_finalfn_3536itversity_retail_dbpg_catalogstring_agg_finalfnFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstring_agg_3538itversity_retail_dbpg_catalogstring_aggNoneNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogbytea_string_agg_transfn_3543itversity_retail_dbpg_catalogbytea_string_agg_transfnFUNCTIONNoneNoneNoneNoneNoneNoneinternalNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_cataloginternalNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogbytea_string_agg_finalfn_3544itversity_retail_dbpg_catalogbytea_string_agg_finalfnFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstring_agg_3545itversity_retail_dbpg_catalogstring_aggNoneNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESNONoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_2012itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_2013itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstr_2085itversity_retail_dbpg_catalogsubstrFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstr_2086itversity_retail_dbpg_catalogsubstrFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_2073itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogsubstring_2074itversity_retail_dbpg_catalogsubstringFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0SQLNoneNoneSQLGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogcstring_in_2292itversity_retail_dbpg_catalogcstring_inFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogcstring_out_2293itversity_retail_dbpg_catalogcstring_outFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogcstring_recv_2500itversity_retail_dbpg_catalogcstring_recvFUNCTIONNoneNoneNoneNoneNoneNonecstringNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogcstringNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogcstring_send_2501itversity_retail_dbpg_catalogcstring_sendFUNCTIONNoneNoneNoneNoneNoneNonebyteaNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogbyteaNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogpg_get_constraintdef_2508itversity_retail_dbpg_catalogpg_get_constraintdefFUNCTIONNoneNoneNoneNoneNoneNonetextNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtextNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALNOMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogjson_strip_nulls_3261itversity_retail_dbpg_catalogjson_strip_nullsFUNCTIONNoneNoneNoneNoneNoneNonejsonNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogjsonNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogstrip_3623itversity_retail_dbpg_catalogstripFUNCTIONNoneNoneNoneNoneNoneNonetsvectorNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogtsvectorNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
itversity_retail_dbpg_catalogjsonb_strip_nulls_3262itversity_retail_dbpg_catalogjsonb_strip_nullsFUNCTIONNoneNoneNoneNoneNoneNonejsonbNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneitversity_retail_dbpg_catalogjsonbNoneNoneNoneNone0EXTERNALNoneNoneINTERNALGENERALYESMODIFIESYESNoneYES0NoneNoneINVOKERNoneNoneNoneNONoneNoneNoneNONoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone
" ], "text/plain": [ "[('itversity_retail_db', 'pg_catalog', 'btvarstrequalimage_5050', 'itversity_retail_db', 'pg_catalog', 'btvarstrequalimage', 'FUNCTION', None, None, None, None, None, None, 'boolean', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bool', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'string_to_array_394', 'itversity_retail_db', 'pg_catalog', 'string_to_array', 'FUNCTION', None, None, None, None, None, None, 'ARRAY', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', '_text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'array_to_string_395', 'itversity_retail_db', 'pg_catalog', 'array_to_string', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'string_to_array_376', 'itversity_retail_db', 'pg_catalog', 'string_to_array', 'FUNCTION', None, None, None, None, None, None, 'ARRAY', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', '_text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'array_to_string_384', 'itversity_retail_db', 'pg_catalog', 'array_to_string', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'strpos_868', 'itversity_retail_db', 'pg_catalog', 'strpos', 'FUNCTION', None, None, None, None, None, None, 'integer', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'int4', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substr_877', 'itversity_retail_db', 'pg_catalog', 'substr', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substr_883', 'itversity_retail_db', 'pg_catalog', 'substr', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_936', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_937', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'pg_get_partition_constraintdef_3408', 'itversity_retail_db', 'pg_catalog', 'pg_get_partition_constraintdef', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'pg_get_constraintdef_1387', 'itversity_retail_db', 'pg_catalog', 'pg_get_constraintdef', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'RI_FKey_restrict_del_1648', 'itversity_retail_db', 'pg_catalog', 'RI_FKey_restrict_del', 'FUNCTION', None, None, None, None, None, None, 'trigger', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'trigger', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'RI_FKey_restrict_upd_1649', 'itversity_retail_db', 'pg_catalog', 'RI_FKey_restrict_upd', 'FUNCTION', None, None, None, None, None, None, 'trigger', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'trigger', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_1680', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'bit', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bit', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_1699', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'bit', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bit', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'string_agg_transfn_3535', 'itversity_retail_db', 'pg_catalog', 'string_agg_transfn', 'FUNCTION', None, None, None, None, None, None, 'internal', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'internal', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'string_agg_finalfn_3536', 'itversity_retail_db', 'pg_catalog', 'string_agg_finalfn', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'string_agg_3538', 'itversity_retail_db', 'pg_catalog', 'string_agg', None, None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'bytea_string_agg_transfn_3543', 'itversity_retail_db', 'pg_catalog', 'bytea_string_agg_transfn', 'FUNCTION', None, None, None, None, None, None, 'internal', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'internal', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'bytea_string_agg_finalfn_3544', 'itversity_retail_db', 'pg_catalog', 'bytea_string_agg_finalfn', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'string_agg_3545', 'itversity_retail_db', 'pg_catalog', 'string_agg', None, None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'NO', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_2012', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_2013', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substr_2085', 'itversity_retail_db', 'pg_catalog', 'substr', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substr_2086', 'itversity_retail_db', 'pg_catalog', 'substr', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_2073', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'substring_2074', 'itversity_retail_db', 'pg_catalog', 'substring', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'SQL', None, None, 'SQL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'cstring_in_2292', 'itversity_retail_db', 'pg_catalog', 'cstring_in', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'cstring_out_2293', 'itversity_retail_db', 'pg_catalog', 'cstring_out', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'cstring_recv_2500', 'itversity_retail_db', 'pg_catalog', 'cstring_recv', 'FUNCTION', None, None, None, None, None, None, 'cstring', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'cstring', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'cstring_send_2501', 'itversity_retail_db', 'pg_catalog', 'cstring_send', 'FUNCTION', None, None, None, None, None, None, 'bytea', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'bytea', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'pg_get_constraintdef_2508', 'itversity_retail_db', 'pg_catalog', 'pg_get_constraintdef', 'FUNCTION', None, None, None, None, None, None, 'text', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'text', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'NO', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'json_strip_nulls_3261', 'itversity_retail_db', 'pg_catalog', 'json_strip_nulls', 'FUNCTION', None, None, None, None, None, None, 'json', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'json', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'strip_3623', 'itversity_retail_db', 'pg_catalog', 'strip', 'FUNCTION', None, None, None, None, None, None, 'tsvector', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'tsvector', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None),\n", " ('itversity_retail_db', 'pg_catalog', 'jsonb_strip_nulls_3262', 'itversity_retail_db', 'pg_catalog', 'jsonb_strip_nulls', 'FUNCTION', None, None, None, None, None, None, 'jsonb', None, None, None, None, None, None, None, None, None, None, None, None, None, None, 'itversity_retail_db', 'pg_catalog', 'jsonb', None, None, None, None, '0', 'EXTERNAL', None, None, 'INTERNAL', 'GENERAL', 'YES', 'MODIFIES', 'YES', None, 'YES', 0, None, None, 'INVOKER', None, None, None, 'NO', None, None, None, 'NO', None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None)]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%sql \n", "\n", "SELECT * FROM information_schema.routines \n", "WHERE routine_name ~ 'str'" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * postgresql://itversity_retail_user:***@localhost:5432/itversity_retail_db\n", "1 rows affected.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", "
substring
hom
" ], "text/plain": [ "[('hom',)]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%sql\n", "\n", "SELECT substring('Thomas' from 2 for 3)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * postgresql://itversity_retail_user:***@localhost:5432/itversity_retail_db\n", "1 rows affected.\n" ] }, { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", "
substring
hom
" ], "text/plain": [ "[('hom',)]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%%sql\n", "\n", "SELECT substring('Thomas', 2, 3)" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.12" } }, "nbformat": 4, "nbformat_minor": 4 }