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

score 2 · Accepted Answer · answered Jul 27 '22 at 14:13

2

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

drop schema """tenant__xyz""";

answered Jul 27 '22 at 14:13

1

Yes, and don't create the new schema with double quotes. You would be attractiing problems. – The Impaler Jul 27 '22 at 14:14
Thanks it worked! @TheImpaler yes it was by accident – Don Jul 27 '22 at 14:15

1 Answers1