On Tue, Mar 22, 2005 at 16:06:59 -0800,
"Marubayashi, Roy (Mission Systems)" <Roy(dot)Marubayashi(at)ngc(dot)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 at what pemissions I've granted and see in the documentation that there is a view called usage_privileges but when I attempt to look at this table (i.e., select * from usage_privileges) I get, 'ERROR: relation "usage_privileges" does not exist'. 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.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-03-27 16:06:03|
|Subject: Re: Time Conversion |
|Previous:||From: Christopher Kings-Lynne||Date: 2005-03-27 05:24:34|
|Subject: Re: [pgsql-advocacy] Function which gives back the nearest neighbours|