Re: pg_dump - 8.3 - schemas

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(dot)klaver(at)gmail(dot)com