postgresqlquoted-identifier

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

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

How can I do this? Thank you in advance

Solution

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

    drop schema """tenant__xyz""";