pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
User attibutes
2+ messages / 2 participants
[nested] [flat]

* User attibutes
@ 2004-01-23 11:26  register@vodafone.es
  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-26 17:02  Tom Lane <tgl@sss.pgh.pa.us>
  parent: register@vodafone.es
  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