In postgresql, Is there a way to drop a user which has objects?

Oh, ownership is a pretty high privilege Why don't you just rename your user and set a new password if you are worried about other permission? or - better! - create a proper role and assign that to new users?

Hello Kousik,

 

REASSIGN OWNED BY was implemented with exactly this use case.