Re: Delete a table automatic?

Поиск
Список
Период
Сортировка
От jian he
Тема Re: Delete a table automatic?
Дата
Msg-id CACJufxEbBvqxx_=a4_z2k2_UQiOxN6YnWC8cMGurYWR0wJKd7w@mail.gmail.com
обсуждение исходный текст
Ответ на Delete a table automatic?  (黄宁 <huangning0722@gmail.com>)
Ответы Re: Delete a table automatic?  (Rob Sargent <robjsargent@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Autovacuum on Partitioned Tables
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Delete a table automatic?