I'm just a noob developer and I have a stored procedure I've created for postgres. The app I'm developing has backend done in
node and I've got to upload the stored procedure to our dev server.
How is this process usually done? I mean, I could just copy the code and paste it on our dev's
pgadmin and that would work. But, creating a
migration file for that would also work. Also, executing a
CREATE OR REPLACE PROCEDURE raw query inside the code itself would also work.
How is the process of uploading a stored procedure on a postgres running server usually done?