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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
