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

Time:07-28

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

How can I do this? Thank you in advance

CodePudding user response:

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

drop schema """tenant__xyz""";
  • Related