Re: pg_dump - 8.3 - schemas - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: pg_dump - 8.3 - schemas
Date
Msg-id 4F3D5B49.3000807@gmail.com
Whole thread Raw
In response to Re: pg_dump - 8.3 - schemas  ("Edward W. Rouse" <erouse@comsquared.com>)
Responses Re: pg_dump - 8.3 - schemas
List pgsql-sql
On 02/16/2012 11:31 AM, Edward W. Rouse wrote:
> To answer the second question first, yes; both as the same user.
>
> pg_dump -v -f $bkfile -F c -U $USER $DATABASE


So how are you determining that only the public schema is being dumped?
One thing to check is the search_path setting in postgresql.conf. This 
can create the illusion that only one schema is available in a database. 
One way to check is to use the fully qualified name for a table you know 
to be in the reports schema. Ex:

select * from reports.some_table;

>
>
>
>
-- 
Adrian Klaver
adrian.klaver@gmail.com


pgsql-sql by date:

Previous
From: "Edward W. Rouse"
Date:
Subject: Re: pg_dump - 8.3 - schemas
Next
From: "Edward W. Rouse"
Date:
Subject: Re: pg_dump - 8.3 - schemas