PostgreSQL - Variables in SQL Scripts

postgresql-sql_scripts_variables.sql

/**

  Usage and expansion of variables in SQL scripts to be executed with psql \i command.
  
*/

-- Expansion with quotes as varchar variables example
\set analysis_id a

delete from warehouse.analysis_tasks where analysis_id = :'analysis_id';
delete from warehouse.properties where analysis_id = :'analysis_id';
delete from sunnsaas.analysis where analysis_id = :'analysis_id';

-- Use in SQL commands body example
\set myvariable value

select * from :myvariable.table1;