How to change permission so I can delete records using pgAdminIII?

tseyfarth 2017-02-11 01:07:48 UTC #1

Hello all,

I am importing data and realized I made a bit of a mistake. I need to delete serveral hundred records in the crmacct table and all of the records in the custinfo table. However, on these tables, pgAdmin reports that I do not have permissions to "maintain.... ". How can I modify the setup so that I either permanently have permission or have permission now, and change it back again?

I am logged in as postgre user.

Thank you,

Tim

tseyfarth 2017-02-11 06:10:17 UTC #2

Found the answer right here

http://dba.stackexchange.com/questions/15144/disable-automatic-login-in-pgadmin

Need to remove the save password in pgAdmin, then login as admin....

Tim