[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] Postgres dump utility
From:       "Glen Parker" <glenebob () nwlink ! com>
Date:       2004-03-05 19:45:52
Message-ID: 00b001c402ea$786cb710$0b01a8c0 () saturn
[Download RAW message or body]

Does anyone know of a way to get the output that pg_dump provides, but split
in pieces?  What I would like is one file with just the schema, one file
with just the data, and one file with just indexes.  To restore the data I
would then:

psql DB < schema.sql
psql DB < data.sql
psql DB < indexes.sql

This would make large schema changes much easier since you wouldn't have to
wade through the GB's of data to find the table definition statements.

Doing two dumps, one for schema and one for data, *almost* does the trick,
but because the indexes will then be created before copying the data in, the
restore operation takes eons :-(

Anyone?

Thx,
Glen Parker


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

[prev in list] [next in list] [prev in thread] [next in thread]