public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mauricio Fernandez <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Script generation through psql
Date: Tue, 21 Oct 2025 17:51:46 -0300
Message-ID: <CAMdfv4XRZXZmZm3NWmjPe69kaAnkRTX_8Jq1qp+Pet9mD4eCaw@mail.gmail.com> (raw)

Hi community

I'm trying to generate an script file as the output from psql script been
called from linux bash, and I've two issues:

The bash call is like:

psql -U myusr-d mydb -f ./scr.sql > $UPD_FILE 2>&1

$ cat scr.sql
\set vl_id 19
\set ECHO none
\pset tuples_only on
\pset pager off

select script_drop from proceso_actualiza_fdw where id = :vl_id;

select script_import from proceso_actualiza_fdw where id = :vl_id;

\q

1.- The output file is like :
*Pager usage is off.*
 --                                                                  *+*
 -- BORRADO DE TABLAS MODIFICADAS                                    +

How can I eliminate "*Pager usage is off." *and the *"+"  *at the end of
each row?

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 example

DO $$
DECLARE
  vl_id integer;
BEGIN
 -- vl_id is set inside the procedure
  call my_procedure(*vl_id*);
END $$;

select script_drop from proceso_actualiza_fdw where id = :*vl_id*;

select script_import from proceso_actualiza_fdw where id = :*vl_id*;

The script output file is the result set from the queries.

I've tried with \set myvar but this doesn't works

Thank you very much in advance

kind regards

Mauricio Fernández

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Script generation through psql
  In-Reply-To: <CAMdfv4XRZXZmZm3NWmjPe69kaAnkRTX_8Jq1qp+Pet9mD4eCaw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox