Re: Novice Question

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