Re: pg_dump and search_path

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump and search_path
Date: 2019-07-09 14:12:13
Message-ID: 49d1a724-f79b-56fe-adef-86e27faed5c4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/9/19 6:28 AM, Ron wrote:

>
> Then should search_path be set at the end of pg_restore?
>

1) That would be to late for anything happening in the restore.

2) The:

SELECT pg_catalog.set_config('search_path', '', false);

only applies to the restore session. After the restore the search_path
will return to whatever has been configured.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-07-09 14:14:44 Re: SuperUser permission denied when creating table.
Previous Message Achilleas Mantzios 2019-07-09 14:08:44 Re: SuperUser permission denied when creating table.