Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 287D66E7E0C
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 15:00:20 -0400 (AST)
Received: from smtp.comsquared.com ([209.155.237.140])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <erouse@comsquared.com>) id 1Ry6Z0-0005IA-0M
	for pgsql-sql@postgresql.org; Thu, 16 Feb 2012 19:00:19 +0000
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	q1GIxucB014105
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 13:59:59 -0500 (EST)
Received: from erouse052008 ([10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	q1GIxrm3014476
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 13:59:55 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
Subject: pg_dump - 8.3 - schemas
Date: Thu, 16 Feb 2012 13:59:54 -0500
Message-ID: <06c601ccecdd$2cbeefa0$863ccee0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Aczs3Sse5zgG0rqBSzWp+ubTIYm4NQ==
Content-Language: en-us
X-Pg-Spam-Score: 0.8 (/)
X-Archive-Number: 201202/49
X-Sequence-Number: 36342

I am working with a database set up by someone else. They set it up so that
most tables are in the public schema, but they also have a reports schema;
database.public.tables and database.reports.tables.

If I do a pg_dump of the database, I only get the public schema. If I do a
dump with --schema=reports, I only get the reports schema. Is there a way to
get all the schemas from a single pg_dump or am I forced to use separate
ones? This is also for future issues where there may be more than 2.

Thanks

Edward W. Rouse