How can I force prefix "pg_" to create new user in postgres?

user_12661527 0
Viewed 106

I have problem with postgres. It is possible to force prefix "pg_" to create user in PostgreSQL? For example:

CREATE USER pg_admin PASSWORD 'qwerty';

I am using PostgreSQL 10.6

postgresql-10 postgresql
1 Answers

This limitation has been in effect since version 9.6, where system roles starting with pg_ were introduced.

You could create a role with a different name and then update rolname in pg_authid, but that would be a bad idea, since PostgreSQL treats such roles differently than others. For example, the role would not be dumped by pg_dumpall -r.

user_64643080
Related