On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
