Postgres: How to drop a schema which has a double quote included in its name?

Question

I have a schema called "tenant__xyz" in my db but need to drop it.

How can I do this? Thank you in advance

Answer 1

You need to double the double quotes (similar to doubling the single quotes in a string value)

drop schema """tenant__xyz""";