PgAdmin 4 – Can’t Create Script on a database

mac os xpgadminpgadmin-4

When I try to CREATE Script on a database I want to use, there is no CREATE Script item in the context menu.
No CREATE Script option
But CREATE Script looks fine on another database. I can select it and it works fine.
with CREATE Script option
Similarly, CREATE Script in the Object menu looks fine when I'm on the other database, but is disabled when I'm on the one that I want.

Is this just some permissions that I don't have on the main database?

My user role is:

CREATE USER [redacted] WITH
  LOGIN
  NOSUPERUSER
  INHERIT
  NOCREATEDB
  NOCREATEROLE
  NOREPLICATION;

GRANT [redacted], [redacted] TO [redacted];

I'm using pgAdmin 4 version 1.6 on Mac OS X El Capitan v 10.11.6.

Best Answer

This CREATE Script option won't display in the context menu if you are connecting to the server with a user that does not have the SUPERUSER privilege or which does not have the CREATEDB privilege.

Related Question