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: 4F3D5B49.3000807@gmail.com (view raw or flat)
Thread:
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
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

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-2014 The PostgreSQL Global Development Group