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.klaver@xxxxxxxxxxx
