Hello all,
Does anyone know if you can use ‘sudo’ in pgAdmin?
Currently my login doesn’t have full access to the system, when I sudo into the admin account I can alter / drop / create objects / permissions etc.
I don’t know the sudo account password and the DevOps team don’t hand this out (I’m a DBA) so when using pgAdmin options are fairly limited.
I can run the commands in a psql console, but it kind of seems a shame to lose the auto complete and ease of use of the gui when writing scripts.
Googling doesn’t appear to display any results and when looking at the help file none of the start options appear to list this as an option.
I’m running pgAdmin 1.20 on Windows 7.
Servers are Linux.
Any suggestions to this would be appreciated.
Thanks,
Adam
