Created a super user, this command createuser --interactive

 Denisoed | Суперпользователь, Создаёт роли, Создаёт БД

but can not delete.

I write DROP ROLE Denisoed; in response comes:

ERROR: the role of "denisoed" does not exist!

  • What gives out SELECT rolname FROM pg_roles; ? Is there such a role? The case of letters matches? - Alex Krass
  • And if DROP ROLE 'Denisoed'; (attention to single quotes)? - D-side
  • @AlexKrass Produces pg_signal_backend Denisoed postgres (3 lines) - Denisoed
  • @ D-side ERROR: syntax error (approximate position: "'Denisoed'") LINE 1: DROP ROLE 'Denisoed'; - Denisoed
  • ... or do they need double ones? - D-side

0