On Tue, 01 Mar 2005 16:30:19 -0500, Michael Romagnoli
<michael(at)houseind(dot)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