X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 973D1D1CB22 for ; Fri, 23 Jan 2004 11:27:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75905-03 for ; Fri, 23 Jan 2004 07:26:58 -0400 (AST) Received: from psismtp8.vodafone.es (back.vodafone.es [212.73.32.158]) by svr1.postgresql.org (Postfix) with ESMTP id 4FEDCD1B48C for ; Fri, 23 Jan 2004 07:26:51 -0400 (AST) Received: from vodafone.es ([192.168.30.97]) by psismtp8.vodafone.es (ESMTP service) with ESMTP id HRXX3T01.8LB for ; Fri, 23 Jan 2004 12:26:17 +0100 From: To: pgsql-admin@postgresql.org Message-ID: Date: Fri, 23 Jan 2004 12:26:17 +0100 X-Mailer: Netscape Webmail MIME-Version: 1.0 Content-Language: es Subject: User attibutes X-Accept-Language: es Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/225 X-Sequence-Number: 12088 Hello, I can set user varibales in postgresql (ALTER USER user SET search-path=3D$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: =A1No te deshagas de m=E1s tesoros!. AlbumSMS es tu=20 bandeja de mensajes cortos. Manda tus SMS favoritos al 300 (coste+impuestos) y entra en=20 www.mivodafone.vodafone.es/servicios/albumsms o en el men=FA WAP de tu=20 m=F3vil para leerlos, organizarlos en carpetas, crearte listas de=20 contactos o enviar tus SMS desde la web... Hasta el 31/1/2004 tendr=E1s 5= =20 SMS nacionales gratis al d=EDa a m=F3viles Vodafone.