postgresql_privs: Add support for procedures with ALL_IN_SCHEMA

[Andersson007]

SUMMARY

Relates to #994

postgresql_privs: Add support for procedures with ALL_IN_SCHEMA

postgresql_privs:
  database: test2_db
  privs: ALL
  roles: test
  objs: ALL_IN_SCHEMA
  type: procedure

I thinks this is relevantly easy to implement, see:

1. postgresql_privs: fix the module mistakes a procedure for a function #996 (create a similar function and put p instead of f to the SQL query, the part without prokind can contain module.fail_json(msg="meaning: for using the feature, you need postgres 11 or later") and don't forget to put a note about postgres version 11+ in note: section and option's description, add CI tests)
2. (postgresql_privs) accept 'ALL_IN_SCHEMA' objs for 'function' type ansible/ansible#35331 (also could be helpful)

If anybody decides to implement this, please PUT a COMMENT HERE about your intention to avoid parallel works

ISSUE TYPE

• Feature Idea

COMPONENT NAME

postgresql_privs

[ansibullbot]

Files identified in the description:

• plugins/modules/database/postgresql/postgresql_privs.py

If these files are inaccurate, please update the component name section of the description or use the !component bot command.

click here for bot help

[ansibullbot]

cc @Dorn- @andytom @b6d @ilicmilan @jbscalia @kostiantyn-nemchenko @matburt @nerzhul @sebasmannem @tcraxs
click here for bot help

[Andersson007]

Added support for procedures #1048