[Feature Request] Support Postgres DB on Admin DB Scan/Clean

[HaddadJoe]

Is your feature request related to a problem? Please describe.

we've been running temporal on a postgres db for a while now and want a way to clean our db.

Describe the solution you'd like

The cli has a clean command for Cassandra but not for postgres.

Additional context

Would you be open for PRs that implement this?