Running function as superuser

[ildiff]

How I can run a function written in plpgsql as superuser when I'm logged into the database as normal user with a restrict access to tables?

[rski]

1) you can set your role to admin and run a function (if you have enough strong privileges)
2) you can create this function from admin account with SECURE DEFINER option. Everybody would run this functions with admin rights.

[ildiff]

Problem solved with the security definer. Thanks a lot rski!