Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 830FE1337B5B for ; Thu, 30 Dec 2010 18:14:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 39592-09 for ; Thu, 30 Dec 2010 22:14:25 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from stan.prospectivdirect.com (mail.prospectiv.com [155.212.59.212]) by mail.postgresql.org (Postfix) with SMTP id 2031C1337B56 for ; Thu, 30 Dec 2010 18:14:24 -0400 (AST) Received: (qmail 18673 invoked from network); 30 Dec 2010 22:14:24 -0000 Received: from unknown (HELO ?192.168.1.87?) (192.168.1.87) by 0 with SMTP; 30 Dec 2010 22:14:24 -0000 Subject: create role From: Tony Capobianco To: pgsql-sql@postgresql.org Content-Type: text/plain; charset="UTF-8" Date: Thu, 30 Dec 2010 17:14:23 -0500 Message-ID: <1293747263.1650.7.camel@tony1.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 (2.28.3-1.fc12) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/107 X-Sequence-Number: 34943 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