On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <walterc@xxxxxxxxxxx> wrote: > >> I granted the app_admin role to my user name. When I try to >> describe the table using the "\d" psql command, it tells me there are no >> relations. > > I believe that this link explains the problem you are seeing: > http://www.postgresql.org/docs/8.3/interactive/role-membership.html Take a look the the inherits keyword. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
