you can use the psql \drds command:
\drds [PATRN1 [PATRN2]] list per-database role settings
Jov
blog: http:amutu.com/blog http://amutu.com/blog
2013/5/28 bricklen brick...@gmail.com
On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson mo...@neadwerx.comwrote:
Oh, and I'd also like to see
On Tue, May 28, 2013 at 2:41 AM, Jov am...@amutu.com wrote:
you can use the psql \drds command:
Perfect! Just what I was looking for. Thanks Jov, and thanks to Joe Conway
as well for a different solution.
Moshe
--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323
How can I show the value of search_path for the database, the user and the
session?
I ask because I cannot explain the following:
$ psql -U postgres -d ises
psql (9.1.4)
Type help for help.
postgres@moshe=devmain:ises=# show search_path;
search_path
---
public, audit_log
(1
On 05/27/2013 11:29 AM, Moshe Jacobson wrote:
How can I show the value of search_path for the database, the user and
the session?
I ask because I cannot explain the following:
$ psql -U postgres -d ises
psql (9.1.4)
Type help for help.
postgres@moshe=devmain:ises=# show
On Mon, May 27, 2013 at 2:47 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
Is the below what you are looking for?
http://www.postgresql.org/**docs/9.2/static/runtime-**config-client.htmlhttp://www.postgresql.org/docs/9.2/static/runtime-config-client.html
On Mon, May 27, 2013 at 3:07 PM, Moshe Jacobson mo...@neadwerx.com wrote:
I'd like to know how to see the search_path setting attached to a
particular user/role independent of the session.
Oh, and I'd also like to see the current setting of the database so I know
what will happen if I clear
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/27/2013 12:16 PM, Moshe Jacobson wrote:
On Mon, May 27, 2013 at 3:07 PM, Moshe Jacobson
mo...@neadwerx.com mailto:mo...@neadwerx.com wrote:
I'd like to know how to see the search_path setting attached to a
particular user/role independent
On Mon, May 27, 2013 at 12:16 PM, Moshe Jacobson mo...@neadwerx.com wrote:
Oh, and I'd also like to see the current setting of the database so I know
what will happen if I clear the user setting.
I think you can find some of what you are looking for here: