Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How can i view the source code of existing stored procedure in vertica?
Hello, I can't display the code of a stored procedure in Vertica. How can I do it?
EXPORT_OBJECTS will show the CREATE statement:
d2=> select export_objects('','raiseXY');
CREATE PROCEDURE public.raiseXY(x int, y varchar)
RAISE NOTICE ''x = %'', x;
RAISE NOTICE ''y = %'', y;
-- some processing statements
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Thank you very much! You helped me a lot!