How to DROP a table from a specific SCHEMA in POSTGRES?

Question

I am using Heroku, and Postgres database.

I somehow have same table but in two different schemas, first one in public, second one in a custom schema I called mySchema. I need to drop the table which is in Public schema.

Should I put the schema name before the table and it will work ? heroku pg:psql -c "DROP TABLE public.myTable;" -a myAppInHeroku

But I need to drop the one in public, and keep the one in mySchema — Sushi, Aug 03 '21 at 08:30

score 0 · Answer 1 · answered Aug 03 '21 at 08:51

0

I just did heroku pg:psql -c "DROP TABLE public.myTable;" -a myAppInHeroku and it removed the table from the public schema as I wanted.

answered Aug 03 '21 at 08:51

Sushi

646
1
13
31

How to DROP a table from a specific SCHEMA in POSTGRES?

1 Answers1