Postgres Pro
Downloads
Home   >   mailing lists

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

From jian he
Subject Re: Delete a table automatic?
Date
Msg-id CACJufxEbBvqxx_=a4_z2k2_UQiOxN6YnWC8cMGurYWR0wJKd7w@mail.gmail.com
Whole thread Raw
In response to Delete a table automatic?  (黄宁 <huangning0722@gmail.com>)
Responses Re: Delete a table automatic?  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view


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 by date:

Previous
From: Ron
Date:
Subject: Re: Autovacuum on Partitioned Tables
Next
From: Rob Sargent
Date:
Subject: Re: Delete a table automatic?