nested sql scripts and variables in Postgres

Question

I need to migrate from Oracle to Postgres.

In Oracle I have .sql files calling nested .sql files (with input and output parameters each one) in this way: nested sql scripts and variables

Looking for a similar solution in Postgres I found this: How to run postgres sql script from another script?

But what happens with the solution: \i other_script.sql

Can I pass input parameters to it? (and if yes, how?) Can I return parameters from it? (and if yes, how?)

Or the other_script.sql and the calling.script share variables?

Or there isn't an equivalent solution for input/output parameters. And variables are not shared between the two .sql files?

Pavel Stehule · Accepted Answer · 2018-10-09 08:59:37Z

0

psql session variables are session based, so you can set any psql variable inside script, and you can read this variable outside script.

\set myvar some value
select :'myvar';

You can read more in psql documentation.

answered Oct 9, 2018 at 8:59

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1