pg_dumping schemes (not schema)

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Postgres Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: pg_dumping schemes (not schema)
Date: 2003-06-24 20:25:07
Message-ID: 20030624202507.27436.qmail@web13404.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Although I group my data topically in databases, most
of the data is integrated on the client side
(MSAccess). That is, tables from different databases
are often joined together during analysis.

I'm thinking of simplifying analysis and
administration by consolidating the databases and
separating the tables into topics using schemes.
Unfortunately, the resulting data dumps would be huge.
The alternative, pg_dumping individual tables, would
result in a very high number of backup files to
manage.

Is there a way to pg_dump a scheme at a time?

Thanks,

Andrew Gould

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Mahler 2003-06-24 20:34:45 Optimizer/Planner levels
Previous Message Andrew Gould 2003-06-24 20:17:39 capturing and storing query statement with rules