Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 1B6836E7E0C
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 15:31:35 -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 1Ry73E-0005x4-CY
	for pgsql-sql@postgresql.org; Thu, 16 Feb 2012 19:31:34 +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
	q1GJVEmj019453; Thu, 16 Feb 2012 14:31:17 -0500 (EST)
Received: from erouse052008 ([10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	q1GJVEdg015496; Thu, 16 Feb 2012 14:31:14 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: "'Adrian Klaver'" <adrian.klaver@gmail.com>
Cc: <pgsql-sql@postgresql.org>
References: <06c601ccecdd$2cbeefa0$863ccee0$@com> <4F3D574A.9010709@gmail.com>
In-Reply-To: <4F3D574A.9010709@gmail.com>
Subject: Re: pg_dump - 8.3 - schemas
Date: Thu, 16 Feb 2012 14:31:15 -0500
Message-ID: <06ca01ccece1$8c86c120$a5944360$@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: Aczs4D3Ed67gCvstR3mBhVfJb/o4pQAAGKhw
Content-Language: en-us
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201202/51
X-Sequence-Number: 36344

To answer the second question first, yes; both as the same user.

pg_dump -v -f $bkfile -F c -U $USER $DATABASE



> -----Original Message-----
> From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
> Sent: Thursday, February 16, 2012 2:22 PM
> To: Edward W. Rouse
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] pg_dump - 8.3 - schemas
> 
> On 02/16/2012 10:59 AM, Edward W. Rouse wrote:
> > 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.
> 
> The pg_dump should work.
> What is the exact command line statement you are using?
> Are doing both dumps as the same user?
> 
> >
> > Thanks
> >
> > Edward W. Rouse
> >
> >
> 
> 
> --
> Adrian Klaver
> adrian.klaver@gmail.com