Script generation through psql

From: Mauricio Fernandez <mmauricio(dot)fernandez(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Script generation through psql
Date: 2025-10-21 20:51:46
Message-ID: CAMdfv4XRZXZmZm3NWmjPe69kaAnkRTX_8Jq1qp+Pet9mD4eCaw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-10-22 03:57:51 Re: Script generation through psql
Previous Message Sbob 2025-10-21 16:31:40 FDW/Foriegn Table pointing to pgpool never gets load balanced