pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUser attibutes
2+ messages / 2 participants
[nested] [flat]
* User attibutes
@ 2004-01-23 11:26 register@vodafone.es
2004-01-26 17:02 ` Re: User attibutes Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: register@vodafone.es @ 2004-01-23 11:26 UTC (permalink / raw)
To: pgsql-admin
Hello,
I can set user varibales in postgresql
(ALTER USER user SET search-path=$owner,public,other;)
and I can reset.
(ALTER USER user RESET search-path)
But, how can I show user variables?
ALTER USER user SHOW search-path; <-- error.
Thanks,
JOAN
__________________________________________________________________
Vodafone publicidad: ¡No te deshagas de más tesoros!. AlbumSMS es tu
bandeja de mensajes cortos. Manda tus SMS favoritos al 300
(coste+impuestos) y entra en
www.mivodafone.vodafone.es/servicios/albumsms o en el menú WAP de tu
móvil para leerlos, organizarlos en carpetas, crearte listas de
contactos o enviar tus SMS desde la web... Hasta el 31/1/2004 tendrás 5
SMS nacionales gratis al día a móviles Vodafone.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: User attibutes
2004-01-23 11:26 User attibutes register@vodafone.es
@ 2004-01-26 17:02 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-01-26 17:02 UTC (permalink / raw)
To: register@vodafone.es; +Cc: pgsql-admin
<register@vodafone.es> writes:
> But, how can I show user variables?
Look in the pg_user view.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-01-26 17:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-23 11:26 User attibutes register@vodafone.es
2004-01-26 17:02 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox