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.kla...@gmail.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
