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?

Best Answer

  • Bryan_HBryan_H Administrator
    Answer ✓

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

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.