| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Marubayashi, Roy (Mission Systems)" <Roy(dot)Marubayashi(at)ngc(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: I'd Like To See Permissions Granted |
| Date: | 2005-03-27 15:54:31 |
| Message-ID: | 20050327155431.GD9280@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-27 16:06:03 | Re: Time Conversion |
| Previous Message | Christopher Kings-Lynne | 2005-03-27 05:24:34 | Re: [pgsql-advocacy] Function which gives back the nearest neighbours |