Skip to main content

Knowledge Document: Extract ddl of the procedure in Vertica

  • September 24, 2025
  • 0 replies
  • 1 view

coest_opentext_com
Forum|alt.badge.img

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)');

Find complete article on support portal