Re: Script generation through psql
| От | David G. Johnston |
|---|---|
| Тема | Re: Script generation through psql |
| Дата | |
| Msg-id | CAKFQuwbL+S0kQiSPt_SzXbOYf8FtrPLLTnUUHq_y1ooyXOffDQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Script generation through psql (Mauricio Fernandez <mmauricio.fernandez@gmail.com>) |
| Ответы |
Re: Script generation through psql
|
| Список | pgsql-admin |
On Tuesday, October 21, 2025, Mauricio Fernandez <mmauricio.fernandez@gmail.com> wrote:
2. If in the psql script I want to pass variable values from an anonymous block to the rest of the script, how can I proceed?. For exampleDO $$
DECLARE
vl_id integer;
BEGIN
-- vl_id is set inside the procedure
call my_procedure(vl_id);
END $$;
You’d have to do something like:
Execute format(‘set script.varname=%L’, value)
Within the DO block then you can do:
Select current_value(‘script.varname’) as psql_var \gexec
Outside of it.
A temporary table works too.
David J.
В списке pgsql-admin по дате отправления: