table("public.my_table").drop() does not work

[olavloite]

Dropping a table by calling the following will fail when using PostgreSQL:

const instance = spanner.instance('my-instance');
const database = instance.database('my-database');
const table = database.table('public.Singers');
table.delete();

The reason is that this line fails to take two things into consideration:

1. PostgreSQL uses " (double quotes) to quote identifiers, and not ` (backtick).
2. If the table name is prefixed with a schema name, then the entire string is quoted, instead of the schema name and table name separately.

The output is:

• Current: DROP TABLE `public.Singers`
• Expected: DROP TABLE "public"."Singers"