1 | specific_catalog | | information_schema.sql_identifier | 0 | |
1 | routine_id | | integer | 0 | The primary key of this table, which is also a serial field. |
2 | specific_schema | | information_schema.sql_identifier | 0 | |
2 | order | | integer | 0 | |
3 | specific_name | | information_schema.sql_identifier | 0 | |
3 | routine_code | | character varying | 12 | |
4 | routine_name | | regproc | 0 | |
4 | routine_catalog | | information_schema.sql_identifier | 0 | |
5 | status | | boolean | 0 | |
5 | routine_schema | | information_schema.sql_identifier | 0 | |
6 | routine_name | | information_schema.sql_identifier | 0 | |
7 | routine_type | | information_schema.character_data | 0 | |
8 | module_catalog | | information_schema.sql_identifier | 0 | |
9 | module_schema | | information_schema.sql_identifier | 0 | |
10 | module_name | | information_schema.sql_identifier | 0 | |
11 | udt_catalog | | information_schema.sql_identifier | 0 | |
12 | udt_schema | | information_schema.sql_identifier | 0 | |
13 | udt_name | | information_schema.sql_identifier | 0 | |
14 | data_type | | information_schema.character_data | 0 | |
15 | character_maximum_length | | information_schema.cardinal_number | 0 | |
16 | character_octet_length | | information_schema.cardinal_number | 0 | |
17 | character_set_catalog | | information_schema.sql_identifier | 0 | |
18 | character_set_schema | | information_schema.sql_identifier | 0 | |
19 | character_set_name | | information_schema.sql_identifier | 0 | |
20 | collation_catalog | | information_schema.sql_identifier | 0 | |
21 | collation_schema | | information_schema.sql_identifier | 0 | |
22 | collation_name | | information_schema.sql_identifier | 0 | |
23 | numeric_precision | | information_schema.cardinal_number | 0 | |
24 | numeric_precision_radix | | information_schema.cardinal_number | 0 | |
25 | numeric_scale | | information_schema.cardinal_number | 0 | |
26 | datetime_precision | | information_schema.cardinal_number | 0 | |
27 | interval_type | | information_schema.character_data | 0 | |
28 | interval_precision | | information_schema.cardinal_number | 0 | |
29 | type_udt_catalog | | information_schema.sql_identifier | 0 | |
30 | type_udt_schema | | information_schema.sql_identifier | 0 | |
31 | type_udt_name | | information_schema.sql_identifier | 0 | |
32 | scope_catalog | | information_schema.sql_identifier | 0 | |
33 | scope_schema | | information_schema.sql_identifier | 0 | |
34 | scope_name | | information_schema.sql_identifier | 0 | |
35 | maximum_cardinality | | information_schema.cardinal_number | 0 | |
36 | dtd_identifier | | information_schema.sql_identifier | 0 | |
37 | routine_body | | information_schema.character_data | 0 | |
38 | routine_definition | | information_schema.character_data | 0 | |
39 | external_name | | information_schema.character_data | 0 | |
40 | external_language | | information_schema.character_data | 0 | |
41 | parameter_style | | information_schema.character_data | 0 | |
42 | is_deterministic | | information_schema.yes_or_no | 0 | |
43 | sql_data_access | | information_schema.character_data | 0 | |
44 | is_null_call | | information_schema.yes_or_no | 0 | |
45 | sql_path | | information_schema.character_data | 0 | |
46 | schema_level_routine | | information_schema.yes_or_no | 0 | |
47 | max_dynamic_result_sets | | information_schema.cardinal_number | 0 | |
48 | is_user_defined_cast | | information_schema.yes_or_no | 0 | |
49 | is_implicitly_invocable | | information_schema.yes_or_no | 0 | |
50 | security_type | | information_schema.character_data | 0 | |
51 | to_sql_specific_catalog | | information_schema.sql_identifier | 0 | |
52 | to_sql_specific_schema | | information_schema.sql_identifier | 0 | |
53 | to_sql_specific_name | | information_schema.sql_identifier | 0 | |
54 | as_locator | | information_schema.yes_or_no | 0 | |
55 | created | | information_schema.time_stamp | 0 | |
56 | last_altered | | information_schema.time_stamp | 0 | |
57 | new_savepoint_level | | information_schema.yes_or_no | 0 | |
58 | is_udt_dependent | | information_schema.yes_or_no | 0 | |
59 | result_cast_from_data_type | | information_schema.character_data | 0 | |
60 | result_cast_as_locator | | information_schema.yes_or_no | 0 | |
61 | result_cast_char_max_length | | information_schema.cardinal_number | 0 | |
62 | result_cast_char_octet_length | | information_schema.cardinal_number | 0 | |
63 | result_cast_char_set_catalog | | information_schema.sql_identifier | 0 | |
64 | result_cast_char_set_schema | | information_schema.sql_identifier | 0 | |
65 | result_cast_character_set_name | | information_schema.sql_identifier | 0 | |
66 | result_cast_collation_catalog | | information_schema.sql_identifier | 0 | |
67 | result_cast_collation_schema | | information_schema.sql_identifier | 0 | |
68 | result_cast_collation_name | | information_schema.sql_identifier | 0 | |
69 | result_cast_numeric_precision | | information_schema.cardinal_number | 0 | |
70 | result_cast_numeric_precision_radix | | information_schema.cardinal_number | 0 | |
71 | result_cast_numeric_scale | | information_schema.cardinal_number | 0 | |
72 | result_cast_datetime_precision | | information_schema.cardinal_number | 0 | |
73 | result_cast_interval_type | | information_schema.character_data | 0 | |
74 | result_cast_interval_precision | | information_schema.cardinal_number | 0 | |
75 | result_cast_type_udt_catalog | | information_schema.sql_identifier | 0 | |
76 | result_cast_type_udt_schema | | information_schema.sql_identifier | 0 | |
77 | result_cast_type_udt_name | | information_schema.sql_identifier | 0 | |
78 | result_cast_scope_catalog | | information_schema.sql_identifier | 0 | |
79 | result_cast_scope_schema | | information_schema.sql_identifier | 0 | |
80 | result_cast_scope_name | | information_schema.sql_identifier | 0 | |
81 | result_cast_maximum_cardinality | | information_schema.cardinal_number | 0 | |
82 | result_cast_dtd_identifier | | information_schema.sql_identifier | 0 | |