Environment
Analytics Database 25.3
Situation
How to extract the DDL of the procedure?
Resolution
One needs to use export_objects to extract DDL of the procedure.
https://docs.vertica.com/25.3.x/en/data-export/db-export-and-import/using-export-functions/exporting-objects/#exporting-individual-objects
SELECT EXPORT_OBJECTS('','raiseXY(int, int)');