How to delete/disable status (open/closed/resolved/onhold)

How to delete/disable status (open/closed/resolved/onhold)

Hi,
One of our customer do not want status resolved in ticket.

Please give me psql query to delete/disable the same

Thanks

                  New to ADSelfService Plus?