Currently, when I need to create/edit a stored procedure in Postgresql, my workflow goes like the following:
- Create/edit the desired function in my "DB Commands" text file
- Copy and paste function into my development database
- Test
- repeat above until it works as desired
- Copy and paste function into my production DB.
To edit an existing function, the workflow is basically the same as above, but I first have to find the function in my file.
This whole workflow just feels kludgy to me. Is there a better way? Or is that essentially the recommended procedure? Thanks.
-----------------------------------------------
5245 Airport Industrial Rd
-----------------------------------------------