| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | Csar Martnez Cabanas <cmcabanas(at)cisgalicia(dot)org> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Pregunta de novato |
| Date: | 2004-09-08 19:26:24 |
| Message-ID: | 200409081626.25376.martin@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
El Mié 08 Sep 2004 09:13, Csar Martnez Cabanas escribió:
> ¿Como cambio el OWNER a una base de datos en postgres?
Como Postgres:
UPDATE pg_database SET datdba =
(SELECT usesysid FROM pg_user WHERE usename = 'usuario nuevo')
WHERE datname = 'nombre base de datos';
--
16:20:02 up 8 days, 5:45, 1 user, load average: 0.07, 0.27, 0.42
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noe Monreal | 2004-09-08 20:29:44 | Stored Procedures en PostGres |
| Previous Message | Mariano E. S. Markowsky | 2004-09-08 19:17:22 | Dar de baja |