| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Mauricio Arrano <jarrano(at)orbi(dot)biz> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: problemas aún con los esquemas |
| Date: | 2005-10-11 14:14:34 |
| Message-ID: | 20051011141434.GA17064@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On Tue, Oct 11, 2005 at 10:57:50AM -0300, Mauricio Arrano wrote:
Hola,
> Se me sigue presentado el siguiente problema al dar permiso a un
> esquema, no puedo verlo
[...]
> admin(at)test=#\c test usuario1;
>
> You are now connected to database "test" as user "usuario1".
>
> usuario1(at)test=>\d
>
> List of relations
>
> Schema | Name | Type | Owner
> --------+------------+-------+-------
> public | provincias | table | pgsql
Te falta este paso (como "usuario1"):
> admin(at)test=#set search_path to esquema1,public;
--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
"No renuncies a nada. No te aferres a nada."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Judith Altamirano Figueroa | 2005-10-11 14:15:17 | ichar |
| Previous Message | Dario | 2005-10-11 13:58:49 | RE: acerca de administracion de memoria |