Hallo Adam,
if you are a dba,
probably what u are looking for is a superuser account.
start pgadmin,
in the sql window,
type create user,
select create user and hit the help/questionmark button
sudo does not exist in sql
mvg,
Wim
Adam Pearson schreef op di 01-09-2015 om 08:49 [+0000]:
> 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
>
>
>
>
>
>
--
mvg,
Wim Bertels
--
Wim Bertels
Lector
UC Leuven-Limburg
--
Things past redress and now with me past care. -- William Shakespeare, "Richard II"