create role - Mailing list pgsql-sql

From Tony Capobianco
Subject create role
Date
Msg-id 1293747263.1650.7.camel@tony1.localdomain
Whole thread Raw
Responses Re: create role
List 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
nulletc....

How can I get this so I don't have to preface the \d with the schema
name every time?  

Thanks.
Tony




pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: create function problem
Next
From: Adrian Klaver
Date:
Subject: Re: create role