Alan McDonald wrote:

>>Is there any plan to implement:
>> CREATE DATABASE 'the_database' ... [FROM] TEMPLATE
>>'the_template_database
>>like in postgresql?
>></doru>
>
> Don't know much about postgresql but we don't have much need for this in
> Firebird. We certainly don't fire it off much at all. When we do have to
> create a db using another as a template, it's very simple to extract the
> metadata from the first and hit the execute after changing the db name.
> Why do you need to do this much? You certainly are not needing to do this at
> run time are you?

We have a number of ways of doing things 'properly' the problem is that
many projects are running selectable engines, and things like the
'CREATE from blank' are often used where the starting point is
PostgreSQL. So far I've managed to get the one's I've been playing with
to modify things so that either a simple script is used, or one of the
DataDictionary approaches. So implementation may not be required, but
could be useful :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services