From: | Tony Capobianco <tcapobianco(at)prospectiv(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | create role |
Date: | 2010-12-30 22:14:23 |
Message-ID: | 1293747263.1650.7.camel@tony1.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I'm successfully executing the below:
create role developer login;
alter role developer set default_tablespace=dev;
alter role developer set search_path=dev,staging, esave, support, email,
public;
grant select on members to developer;
grant create on schema dev to developer;
However, when I do this:
psql (8.4.5, server 8.4.2)
Type "help" for help.
esave_dw=> \d members
Did not find any relation named "members".
esave_dw=>
esave_dw=> \d esave.members
Table "esave.members"
Column | Type | Modifiers
---------------------+-----------------------------+-----------
memberid | numeric | not null
etc....
How can I get this so I don't have to preface the \d with the schema
name every time?
Thanks.
Tony
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2010-12-30 22:23:10 | Re: create role |
Previous Message | Gary Stainburn | 2010-12-30 20:16:02 | Re: create function problem |