Detect who ran DROP schema

[Siraj G <tosiraj.g@xxxxxxxxx>]

Hello -

A schema was dropped from our UAT environment on 18th July. We are trying to find out who did. We have only one user in our environment, i.e., postgres, but we are trying to identify from where the connection was initiated, which issued DROP schema. Can anyone help?

Regards

Siraj