| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | "linder poclaba lazaro" <linder(dot)poclaba(at)gmail(dot)com> |
| Cc: | edukoski(at)montevideo(dot)com(dot)uy, pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Postgre - PHP |
| Date: | 2006-05-16 01:44:27 |
| Message-ID: | c2d9e70e0605151844q1c075ad0hd53281dc78186413@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On 5/15/06, linder poclaba lazaro <linder(dot)poclaba(at)gmail(dot)com> wrote:
> Conectate a template1 y ejecutas la consulta
>
> select datname from pg_database where datistemplate='f';
>
> te sacará los nombres de las bases de datos que heredan de template1
>
>
tiene que ser una a la que alguien se pueda conectar:
select datname from pg_database where datistemplate='f' and datallowconn = 't';
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2006-05-16 01:49:58 | Re: Ayuda con instalación de postgres para aplicación Windows |
| Previous Message | John Oviedo | 2006-05-16 01:15:15 | Re: PostgreSQL 8.1 sobre Debian Sarge (stable) |