here is the complete CREATE DATABASE from Postgres level 9
 
CREATE DATABASE name
    [ [ WITH ] [ OWNER [=] user_name ]
       
           [ TEMPLATE [=] template ]
           [ ENCODING [=] encoding ]
           [ LC_COLLATE [=] lc_collate ]
           [ LC_CTYPE [=] lc_ctype ]
           [ TABLESPACE [=] tablespace ]
           [ CONNECTION LIMIT [=] connlimit ] ]
 
 
Best regards

--- On Wed, 3/23/11, Jamie Cameron <jcameron@webmin.com> wrote:

From: Jamie Cameron <jcameron@webmin.com>
Subject: Re: [webmin-l] [WEBMIN] Template name needed for "Create Database"
To: "Webmin users list" <webadmin-list@lists.sourceforge.net>
Date: Wednesday, March 23, 2011, 2:12 PM

I guess this could be added - what parameter to CREATE TABLE would you use to specify the template though? 
On 23/Mar/2011 07:22 Francisco Leovey <fleovey@yahoo.com> wrote ..
Jamie:
When attempting to create a new database... using PostgreSQL 8.4
If character set encoding is set to SQL_ASCII
then it errs because Template1 is utf-8
For this case you must supply the appropiate template and Webmin does not have the field to do it ( I checked in all the themes)
Please add it as an option to the newdb_form.cgi
Thank you



-----Inline Attachment Follows-----

------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar

-----Inline Attachment Follows-----

-
Forwarded by the Webmin mailing list at webadmin-list@lists.sourceforge.net
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list