# Is it possible to delete rows from the table you are loading data from? Example: We load data from Postgres database with RDS query component and would like to delete all the rows in the table after the rows are loaded

**URL:** <https://matillioncommunity.discourse.group/t/is-it-possible-to-delete-rows-from-the-table-you-are-loading-data-from-example-we-load-data-from-postgres-database-with-rds-query-component-and-would-like-to-delete-all-the-rows-in-the-table-after-the-rows-are-loaded/1644>\
**Category:** Matillion ETL\
**Created:** [February 8, 2022, 7:27am UTC](https://matillioncommunity.discourse.group/t/is-it-possible-to-delete-rows-from-the-table-you-are-loading-data-from-example-we-load-data-from-postgres-database-with-rds-query-component-and-would-like-to-delete-all-the-rows-in-the-table-after-the-rows-are-loaded/1644 "2022-02-08T07:27:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kerly.klee](https://avatars.discourse-cdn.com/v4/letter/k/c77e96/32.png) [@kerly.klee](https://matillioncommunity.discourse.group/u/kerly.klee)\
**Post date:** [February 8, 2022, 7:27am UTC](https://matillioncommunity.discourse.group/t/is-it-possible-to-delete-rows-from-the-table-you-are-loading-data-from-example-we-load-data-from-postgres-database-with-rds-query-component-and-would-like-to-delete-all-the-rows-in-the-table-after-the-rows-are-loaded/1644/1 "2022-02-08T07:27:28Z")

</div>

Is it possible to delete rows from the table you are loading data from? Example: We load data from Postgres database with RDS query component and would like to delete all the rows in the table after the rows are loaded.

---

<div class="post-metadata">

**Author:** ![ganesh\_pitchai](https://avatars.discourse-cdn.com/v4/letter/g/67e7ee/32.png) [@ganesh\_pitchai](https://matillioncommunity.discourse.group/u/ganesh_pitchai)\
**Post date:** [August 26, 2022, 5:53pm UTC](https://matillioncommunity.discourse.group/t/is-it-possible-to-delete-rows-from-the-table-you-are-loading-data-from-example-we-load-data-from-postgres-database-with-rds-query-component-and-would-like-to-delete-all-the-rows-in-the-table-after-the-rows-are-loaded/1644/2 "2022-08-26T17:53:52Z")

</div>

Not possible in Matillion Components in apply the commands in Source dB's. But you can write the python script and achieve this.