Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and search_path - Mailing list pgsql-general

From Ryan Lambert
Subject Re: pg_dump and search_path
Date
Msg-id CAN-V+g9sopbD5uuRhYieHroqumHWJewRV4HKzByZOegxSh+ZuQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump and search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_dump and search_path
List pgsql-general
Tree view
I had a similar problem and was able to being the command with the search_path to work around it.  I did this on Linux and it looks like you are on Windows but I maybe you can do something similar that will work?

PGOPTIONS='-c search_path=staging, transient, pg_catalog'


Ryan Lambert
RustProof Labs


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: DRY up GUI wiki pages
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump and search_path