Re: Delete a table automatic? - Mailing list pgsql-general

On Tue, Nov 1, 2022 at 2:33 PM 黄宁 <huangning0722@gmail.com> wrote:

I now have two tables named A and B. Table B is calculated based on the data of table A. I wonder if table B can be automatically deleted when table A is deleted？

Your question seems not that specific.

You can use https://dbfiddle.uk/btGcOH30 to showcase your specific problem/question.

you can use DROP TABLE CASCADE.

DROP TABLE manual: https://www.postgresql.org/docs/current/sql-droptable.html

--

 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian