79766511

Date: 2025-09-16 17:21:44
Score: 0.5
Natty:
Report link

To execute the file myInsertFile.sql from the command line in a specific schema, I would suggest:

psql -d myDataBase -a

and then in the psql prompt:

myDataBase=>set search_path to my_schema_01;
SET
myDataBase=>\i myInsertFile.sql

This will execute the sql file with the search path set.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Marco