Re: pg_dump and search_path

On 7/10/19 1:19 PM, Ryan Lambert wrote:
> 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'

Not sure how that worked:

export PGOPTIONS="-c search_path=public"

psql -d test -U postgres

psql (11.4)
Type "help" for help.

test_(postgres)# show search_path;
search_path
-------------
public

test_(postgres)# SELECT pg_catalog.set_config('search_path', '', false);
set_config
------------

(1 row)

test_(postgres)# show search_path;
search_path
-------------

(1 row)

>
>
> *Ryan Lambert*
> RustProof Labs
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com