Re: How to execute .sql file inside a postgres schema

On 4/29/19 7:02 AM, Daulat Ram wrote:
> Hello team,
>
> I have a database name “kbdb” that is having a schema “kb” and I want to
> execute the test.sql file inside this schema,
>
> Please help how we can do that.

You can do as Daniel suggested but be aware that it is equivalent to:

https://www.postgresql.org/docs/11/sql-set.html
SET search_path TO value

That means if you have objects in the script that are not schema
qualified and need to point to other schemas then things will fail. A
longer term solution would to schema qualify the objects in your script.
This is assuming that the script is not generic and is meant to 'float'
from schema to schema.

>
> Regards,
>
> Daulat
>

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