| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | James Hall <James(dot)Hall(at)RadioShack(dot)com> |
| Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Custom Templates? |
| Date: | 2001-10-17 07:11:40 |
| Message-ID: | 200110170712.f9H7BePo012371@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
James Hall wrote:
>I would like to make a custom template for creating databases, but I am
>having a difficult time finding documentation online to assist me. If anyone
>can point me in the right direction it would be appreciated.
By default, a new database copies everything in template1.
If you want to use a special template, you can use:
CREATE DATABASE name WITH TEMPLATE = special_template;
but read the man page first (man create_database).
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Trust in the LORD, and do good..." Psalms 37:3
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2001-10-17 12:35:52 | Re: Where info on new releases? |
| Previous Message | Josh Berkus | 2001-10-17 00:07:47 | Re: postgresql.conf |