create role

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

Responses

Browse pgsql-sql by date

  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