# Automatically insert into table on Liquibase Update
**URL:** https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169
**Category:** General Discussion
**Created:** [March 4, 2024, 4:23pm UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169 "2024-03-04T16:23:39Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@RolandP](https://forum.liquibase.org/u/RolandP)
#### Post date: [March 4, 2024, 4:23pm UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169/1 "2024-03-04T16:23:39Z")
Hi,
we are trying to switch to Liquibase in our company. We found that logging of the statements with Liquibase is possible and it works. Now we would like to know, if there is a way, to automatically insert the executed SQL statements in a DB Table? Normally, with our old System we logged the DDL statements, therefore the question. But i didn’t found anything about such a possibility.
Thanks!
---
### Author:  [@daryldoak](https://forum.liquibase.org/u/daryldoak)
#### Post date: [March 4, 2024, 10:01pm UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169/2 "2024-03-04T22:01:59Z")
With the right logging level (sql-log-level=INFO) Liquibase will provide every executed SQL statement in the output. We take that output and insert it into a table for history.
---
### Author:  [@RolandP](https://forum.liquibase.org/u/RolandP)
#### Post date: [March 5, 2024, 7:12am UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169/3 "2024-03-05T07:12:44Z")
Thank you daryldoak. How do you take that output? Did you write an own program that reads that log file? Or is there a way to let this do liquibase automatically?
---
### Author:  [@daryldoak](https://forum.liquibase.org/u/daryldoak)
#### Post date: [March 5, 2024, 2:22pm UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169/4 "2024-03-05T14:22:42Z")
We wrote our own program.
---
### Author:  [@wwillard](https://forum.liquibase.org/u/wwillard)
#### Post date: [March 6, 2024, 5:45pm UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169/5 "2024-03-06T17:45:48Z")
Another option would be to use the `update-sql` command, which shows all the SQL that will be executed. That could be inserted without needing to strip the logging.
---
### Author:  [@RolandP](https://forum.liquibase.org/u/RolandP)
#### Post date: [March 7, 2024, 7:15am UTC](https://forum.liquibase.org/t/automatically-insert-into-table-on-liquibase-update/9169/6 "2024-03-07T07:15:10Z")
Thank you all for your help.