Skip to main content
Question

How can i view the source code of existing stored procedure in vertica?

  • September 14, 2022
  • 2 replies
  • 7 views

yehudit

Hello, I can't display the code of a stored procedure in Vertica. How can I do it?

2 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • September 14, 2022

EXPORT_OBJECTS will show the CREATE statement:

d2=> select export_objects('','raiseXY');

export_objects

CREATE PROCEDURE public.raiseXY(x int, y varchar)
LANGUAGE 'PL/vSQL'
SECURITY INVOKER
AS '
BEGIN
RAISE NOTICE ''x = %'', x;
RAISE NOTICE ''y = %'', y;
-- some processing statements
END;
';


yehudit
  • Author
  • New Participant
  • September 15, 2022

Thank you very much! You helped me a lot!