It is possible to simple way to produce a copy of the database or schema in PostgreSQL 8.1?

I am testing some software which does lots of updates to particular schema inside a database, and Let me create a copy from it in order to run some evaluations from the original.

pg_dump using the --schema-only option. (Link would go to 7.4 paperwork but when you simply Google pg_dump you're going to get links to each version)

Whether it's on a single server, you simply make use of the CREATE DATABASE command using the TEMPLATE parameter. For instance:


this is a connect to some examples of copying and rebuilding. You should use the backup to revive to another server or whatever