PostgreSQL Revocation Statements doesn't allow multiline queries

[melkorm]

Describe the bug
PostgreSQL Revocation Statements doesn't allow multiline queries as opposed to creation statements which take into consideration multline queries by searching for END keywords. Revocation statement lacks this logic.

To Reproduce
Steps to reproduce the behavior:

1. Create any PostgreSQL backend
2. For revocation statement use "DO $$ BEGIN CREATE ROLE \"reassign\"; EXCEPTION WHEN duplicate_object THEN RAISE NOTICE '%, moving to next statement', SQLERRM USING ERRCODE = SQLSTATE; END $$;"
3. See error in vault logs about PostgreSQL syntax error.

Expected behavior
Revocation statements should consider multiline queries.

Environment:

• Vault Server Version (retrieve with vault status): 1.10.3
• Vault CLI Version (retrieve with vault version): 1.10.3
• Server Operating System/Architecture: Linux amd64