I am using PostgeSQL for one of my projects and have multiple schemas. For example "finance".
In that schema, I have some functions like "finance.convert_money()".
When I right-click it and select Go to DDL, there are two things that do not go as I would expect:
1. CREATE FUNCTION instead CREATE OR REPLACE
2. Name of the function doesn't have a schema, which means DDL would create a copy in public schema
CREATE FUNCTION convert_money instead CREATE OR REPLACE FUNCTION finance.covert_money
Is it possible to change this behaviour?