On 2/20/08, Kynn Jones <kynnjo@xxxxxxxxx> wrote: > Alternatively, is there a better way to streamline the duplication of a > database? How about: CREATE DATABASE newdb TEMPLATE olddb; (don't remember the exact syntax, but it'll be in the docs for CREATE DATABASE). I think the 'createdb' program also has an option for choosing the template. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster