Someone has create a table that has a double quote in its name i.e.

tabschema.tab"name

I have to drop it, but that double quote is messing everything up. I have done it long time back, but now not able to find a solution.

anyone has a solution?

Thank you

Enclosing in single quote or using 2 double quotes or using reverse slash before " to negate the special meaning come to mind

'tab"nm' "tab""nm" tab\"nm

if it does not work, export table, drop all tables with this schema (admin_drop_schema proc), and import to recreate all other tables. Of course it depends on how many other tables are under this schema.

Single quotes are string delimiters. Here we have an identifier and you need to enclose that in double-quotes. So the 2nd option given by dbamota works - the other 2 don't.