Tracking: System Information Functions

[KeXiangWang]

To support more ORM tools, it's necessary to add more system information functions/expressions. Here's the corresponding list in Postgres.

Session Information Functions

• Support current_catalog system column. #17117
• current_database
• current_query
• current_role
• current_schema
• current_schemas
• current_user
• inet_client_addr
• inet_client_port
• inet_server_addr
• inet_server_port
• pg_backend_pid
• pg_conf_load_time
• pg_is_other_temp_schema
• pg_listening_channels
• pg_my_temp_schema
• pg_postmaster_start_time
• pg_trigger_depth
• session_user
• user

Access Privilege Inquiry Functions

• TODO

Schema Visibility Inquiry Functions

• TODO

System Catalog Information Functions

• format_type(type_oid, typemod)
• pg_get_constraintdef(constraint_oid)
• pg_get_constraintdef(constraint_oid, pretty_bool)
• pg_get_expr(pg_node_tree, relation_oid)
• pg_get_expr(pg_node_tree, relation_oid, pretty_bool)
• pg_get_functiondef(func_oid)
• pg_get_function_arguments(func_oid) (not used by sqlalchemy)
• pg_get_function_identity_arguments(func_oid) (not used by sqlalchemy)
• pg_get_function_result(func_oid) (not used by sqlalchemy)
• pg_get_indexdef(index_oid) feat(expr): support pg_get_indexdef #14073
• pg_get_indexdef(index_oid, column_no, pretty_bool) feat(expr): support pg_get_indexdef #14073
• pg_get_keywords() setof (not used by sqlalchemy)
• pg_get_ruledef(rule_oid) (not used by sqlalchemy)
• pg_get_ruledef(rule_oid,
• pg_get_serial_sequence(table_name, column_name)
• pg_get_triggerdef(trigger_oid) (not used by sqlalchemy)
• pg_get_triggerdef(trigger_oid, (not used by sqlalchemy)
• pg_get_userbyid(role_oid) (not used by sqlalchemy)
• pg_get_viewdef(view_name)
• pg_get_viewdef(view_name, pretty_bool)
• pg_get_viewdef(view_oid) feat(catalog): add pg_get_viewdef #14336
• pg_get_viewdef(view_oid, pretty_bool)
• pg_get_viewdef(view_oid, wrap_column_int)
• pg_options_to_table(reloptions)
• pg_tablespace_databases(tablespace_oid)
• pg_tablespace_location(tablespace_oid)
• pg_typeof(any)
• collation for (any)
• to_regclass(rel_name)
• to_regproc(func_name)
• to_regprocedure(func_name)
• to_regoper(operator_name)
• to_regoperator(operator_name)
• to_regtype(type_name)
• to_regnamespace(schema_name)
• to_regrole(role_name)

System Catalog Information Functions used by SQLAlchemy 1.4.x

• format_type(type_oid, typemod)
• pg_get_constraintdef(constraint_oid)
• pg_get_constraintdef(constraint_oid, pretty_bool)
• pg_get_expr(pg_node_tree, relation_oid)
• pg_get_expr(pg_node_tree, relation_oid, pretty_bool)
• pg_get_serial_sequence(table_name, column_name)
• pg_get_viewdef(view_name)