I am pretty new to Postgresql. I have a database with a schema, ill call it ‘FOO’ here in the message. I also have a developer, who want’s to create a function for use in the ‘FOO’ schema. Im not finding the appropriate command to allow that user to create a function in the FOO schema (or elsewhere). Is there such a command? I was looking under the ‘GRANT’ but I don’t see a way to grant “CREATE or REPLACE FUNCTION”. Am I missing anything here? What is the best approach? |
