Re: which database to login to to create global users?
От | Tom Lane |
---|---|
Тема | Re: which database to login to to create global users? |
Дата | |
Msg-id | 19809.1136321840@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: which database to login to to create global users? (pres <pgn.lists@gmail.com>) |
Ответы |
Re: which database to login to to create global users?
Re: which database to login to to create global users? |
Список | pgsql-novice |
pres <pgn.lists@gmail.com> writes: > so, if i understand you correctly, it does not matter which database i'm > logged into when i create a role? Correct. > where (what database/table), then, are theses assignments stored? The info related to roles is stored in some "shared" catalogs that are visible in every database --- just the same way that pg_database is visible in every database. Try this to see which catalogs are shared: select relname from pg_class where relisshared and relkind = 'r'; See also the documentation on the system catalogs: http://www.postgresql.org/docs/8.1/static/catalogs.html The description of each catalog takes care to mention it if the catalog is shared across databases. regards, tom lane
В списке pgsql-novice по дате отправления: