Skip site navigation (1) Skip section navigation (2)

Re: pg_dump - 8.3 - schemas

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump - 8.3 - schemas
Date: 2012-02-16 19:38:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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

In response to


pgsql-sql by date

Next:From: Edward W. RouseDate: 2012-02-16 20:17:48
Subject: Re: pg_dump - 8.3 - schemas
Previous:From: Edward W. RouseDate: 2012-02-16 19:31:15
Subject: Re: pg_dump - 8.3 - schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group