Calling a Procedure or Function in Postgres
I think PL/SQL programmers who move to Postgres all run into the same thing, how do I run the procedure or function once I’ve created it?
Obviously, it’s easy when you are calling it from another stored procedure or function. What most mean, is how do I call it from the command line? That’s easy too.
Using my function and procedure from earlier posts, i.e. 10 Steps to Creating a Function In PostgreSQL Using PLpgSQL and Creating a Procedure In PostgreSQL Using PLpgSQL.
To call either the function or the procedure, you can run:
SELECT * FROM func_1();
You must include the ().
Same for the procedure.
SELECT * FROM proc_1();
Of course, if you are using a GUI tool like PgAdmin III, it’s a somewhat different story. You need to open the query window but the syntax will be the same.
You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.