Truncate partitioned table - PostgreSQL

Question

I have a master table called fact_sgw and have a child table called fact_sgw_2016_06 which is just data for June 2016. Could I truncate the child table without losing any data from the master table (fact_sgw)?

use TRUNCATE ONLY childtablename - see in docu - postgresql.org/docs/current/static/sql-truncate.html — JosMac
– JosMac, Commented Jun 22, 2017 at 12:30

Binita Bharati · Accepted Answer · 2022-02-21 13:16:18Z

2

TRUNCATE TABLE <child_table_name> works fine on Postgres 14.

answered Feb 21, 2022 at 13:16

Binita Bharati

6,0861 gold badge48 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Truncate partitioned table - PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related