create role
От | Tony Capobianco |
---|---|
Тема | create role |
Дата | |
Msg-id | 1293747263.1650.7.camel@tony1.localdomain обсуждение исходный текст |
Ответы |
Re: create role
|
Список | 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 по дате отправления: