create database newdb template olddb;
works as well.
-Chris
On Tuesday 01 March 2005 05:08 pm, javier wilson wrote:
> On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli
>
> <michael@houseind.com> wrote:
> > Sorry, I meant to ask about copying databases, not tables (including all
> > data in the database as per below).
>
> you can do a pg_dump your_database>your_database.dump.sql
> and then createdb to create your new database, and finally
> pgsql -f your_database.dump.sql new_database
>
> and that's it. you should probably use -Upostgres
> depending on what kind of security you use.
>
> javier
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org