On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli <michael@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx
