[GENERAL] Reusable pl/pgsql samples ?

Hello all,   Is there anybody know where I can find reusable pl/pgsql samples or function library ?     Thanks,   Armen

Re: [GENERAL] Reusable pl/pgsql samples ?

t: Re: [GENERAL] Reusable pl/pgsql samples ? Roberto Mello used to maintain a PL/PgSQL Cookbook, but this link is dead, and I don't know if it's still around: http://techdocs.postgresql.org/redir.php?link=http:// www.brasileiro.net/postgres/cookbook -tfo On Oct 11, 2004, at 4:05 AM, Ar

[GENERAL] How to get user's role?

Hi all,   I want to get what roles/groups that the current user is member of. I tried to use the following commands but they both returned no rows.   SELECT * FROM information_schema.enabled_roles SELECT * FROM information_schema.applicable_roles   Anybody know how to solve this ? or anyb