Re: I'd Like To See Permissions Granted - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: I'd Like To See Permissions Granted
Date
Msg-id 20050327155431.GD9280@wolff.to
Whole thread Raw
In response to I'd Like To See Permissions Granted  ("Marubayashi, Roy (Mission Systems)" <Roy.Marubayashi@ngc.com>)
List pgsql-novice
On Tue, Mar 22, 2005 at 16:06:59 -0800,
  "Marubayashi, Roy (Mission Systems)" <Roy.Marubayashi@ngc.com> wrote:
> I'm just getting started using PostgreSQL and I was successfully able to create a table.  I'd like to be able to look
atwhat pemissions I've granted and see in the documentation that there is a view called usage_privileges but when I
attemptto look at this table (i.e., select * from usage_privileges) I get, 'ERROR:  relation "usage_privileges" does
notexist'.  What do I need to do in order to look at the contents of this view? 

The information_schema schema probably isn't in your search path. You
can refer to the table by qualifying its name with the schema or
changing your search path.

pgsql-novice by date:

Previous
From: Marc Ayres
Date:
Subject: Windows 2000 Installation Issue
Next
From: Tom Lane
Date:
Subject: Re: Time Conversion