On 16/12/2010 10:12, Andrus Moor wrote:
> Robert,
>
>> I'm probably misunderstanding but "CREATE DATABASE foo TEMPLATE bar"
>> will clone bar as foo including data. Of course this only works within
>> the same cluster.
>
> Than you.
> You are genious
> I haven't never tought about this.
>
> Will this work if database bar is accessed by other users ? Probably it
> fails, so it cannot used.
I don't know for sure, but I don't see why it should fail - it's only
reading it, not writing data to it or making any changes.
> Will this command create exact copy ?
Why wouldn't it? :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
