How to drop a table in PostgreSQL which includes double quotes in its name

Question

I accidentaly created a table in PostgreSQL which contains, in its name, some double quotes. I used SQL Server 2000 DTS to import data from it to my PostgreSQL server, but while importing, it created the table but with double quotes in it.

Actually the table name when I do

SELECT * FROM pg_tables

is :

public","t_freemailer

So, when I try to drop the table using something like :

DROP TABLE "public"."public","t_freemailer"

I get an error : ERROR: table "public" does not exist

And I did not found a way to escape doubles quotes in identifiers name.

Please help

Answer 1

Use "double" double quotes to escape:

DROP TABLE "public"."public"",""t_freemailer"

Here's a link to the documentation

Answer 2

2 x double quote = quote...

DROP TABLE "public"."public"",""t_freemailer"