Removing accounts

Can somebody let me know how I would remove an account from the posgreSQL database?

I can see the tables, but don't know where the accounts are held or the sql statement to delete them.

Thank you.