\pset tuples_only
with
a as (
 select oid::regprocedure,obj_description(oid) from pg_proc p where proname like 'ddlx_%'
 order by obj_description(oid) is null, cast(oid::regprocedure as text) collate "C"
)
select * from a
;
 ddlx_create(oid,text[])               | Get SQL CREATE statement for a generic object by object id
 ddlx_create(regclass)                 | Get SQL CREATE statement for a table, view, sequence or index
 ddlx_create(regconfig)                | Get SQL CREATE statement for a text search configuration
 ddlx_create(regdictionary)            | Get SQL CREATE statement for a text search dictionary
 ddlx_create(regnamespace)             | Get SQL CREATE statement for a schema
 ddlx_create(regoper)                  | Get SQL CREATE statement for an operator
 ddlx_create(regoperator)              | Get SQL CREATE statement for an operator
 ddlx_create(regproc)                  | Get SQL CREATE statement for a routine
 ddlx_create(regprocedure)             | Get SQL CREATE statement for a routine
 ddlx_create(regrole)                  | Get SQL CREATE statement for a role
 ddlx_create(regtype)                  | Get SQL CREATE statement for a user defined data type
 ddlx_drop(oid)                        | Get SQL DROP statement for an object by object id
 ddlx_script(oid,text[])               | Get SQL DDL script for an object and dependants by object id
 ddlx_script(text,text[])              | Get SQL DDL script for an object and dependants by object name
 ddlx_alter_class(regclass)            | 
 ddlx_alter_owner(oid)                 | 
 ddlx_alter_role_auth(oid)             | 
 ddlx_alter_sequence(regclass)         | 
 ddlx_alter_table_defaults(regclass)   | 
 ddlx_alter_table_rls(regclass)        | 
 ddlx_alter_table_storage(regclass)    | 
 ddlx_apropos(text)                    | 
 ddlx_banner(text,text,text,text,text) | 
 ddlx_comment(oid)                     | 
 ddlx_create_access_method(oid)        | 
 ddlx_create_aggregate(regproc)        | 
 ddlx_create_amop(oid)                 | 
 ddlx_create_amproc(oid)               | 
 ddlx_create_cast(oid)                 | 
 ddlx_create_class(regclass)           | 
 ddlx_create_collation(oid)            | 
 ddlx_create_constraint(oid)           | 
 ddlx_create_constraints(regclass)     | 
 ddlx_create_conversion(oid)           | 
 ddlx_create_database(oid)             | 
 ddlx_create_default(oid)              | 
 ddlx_create_event_trigger(oid)        | 
 ddlx_create_foreign_data_wrapper(oid) | 
 ddlx_create_function(regproc)         | 
 ddlx_create_index(regclass)           | 
 ddlx_create_indexes(regclass)         | 
 ddlx_create_language(oid)             | 
 ddlx_create_operator_class(oid)       | 
 ddlx_create_operator_family(oid)      | 
 ddlx_create_policy(oid)               | 
 ddlx_create_publication(oid)          | 
 ddlx_create_rule(oid)                 | 
 ddlx_create_rules(regclass)           | 
 ddlx_create_sequence(regclass)        | 
 ddlx_create_server(oid)               | 
 ddlx_create_subscription(oid)         | 
 ddlx_create_table(regclass)           | 
 ddlx_create_tablespace(oid)           | 
 ddlx_create_text_search_parser(oid)   | 
 ddlx_create_text_search_template(oid) | 
 ddlx_create_transform(oid)            | 
 ddlx_create_trigger(oid)              | 
 ddlx_create_triggers(regclass)        | 
 ddlx_create_type_base(regtype)        | 
 ddlx_create_type_domain(regtype)      | 
 ddlx_create_type_enum(regtype)        | 
 ddlx_create_type_range(regtype)       | 
 ddlx_create_type_shell(regtype)       | 
 ddlx_create_user_mapping(oid)         | 
 ddlx_create_view(regclass)            | 
 ddlx_describe(regclass)               | 
 ddlx_drop_amop(oid)                   | 
 ddlx_drop_amproc(oid)                 | 
 ddlx_drop_constraint(oid)             | 
 ddlx_drop_default(oid)                | 
 ddlx_drop_trigger(oid)                | 
 ddlx_get_constraints(regclass)        | 
 ddlx_get_dependants(oid)              | 
 ddlx_get_functions(regproc)           | 
 ddlx_get_indexes(regclass)            | 
 ddlx_get_rules(regclass)              | 
 ddlx_get_triggers(regclass)           | 
 ddlx_grants(oid)                      | 
 ddlx_grants(regclass)                 | 
 ddlx_grants(regproc)                  | 
 ddlx_grants(regrole)                  | 
 ddlx_grants_columns(regclass)         | 
 ddlx_identify(oid)                    | 
 ddlx_script_parts(oid,text[])         |