PostgreSQL: How to set value to variable using 'execute'?

Question

I have a query which is assigned to some variable and I want to execute it with setting some values.

Example:

create or replace function funct1(a int)
returns void as
$$
declare
       wrclause varchar := '';
       sqlq varchar ;
       t varchar;
begin
     IF (a IS NOT NULL ) THEN 
        wrclause := 'where C = '|| a ||' AND C IN ('|| a || ')';
     END IF;


     sqlq := ' t :=select string_agg(''select *, abcd as "D" from '' || table_namess  ||, '' Union all '') as namess
     from tablescollection2 ud
     inner join INFORMATION_SCHEMA.Tables so on ud.table_namess = so.Table_name ' || wrclause;

      raise info '%',sqlq;

      execute sqlq; /* How to set value to variable f.ex (t varchar output,t output)*/

      raise info '%',t;
end;
$$
language plpgsql;

In SQL Server: We can use

exec sp_executesql @sqlq, N'@t nvarchar(max) output', @t OUTPUT;

Note: How can I do in the PostgreSQL?

MyTry:

execute sqlq(t varchar output,t output); /* getting error near varchar */

Ilesh Patel · Accepted Answer · 2014-07-11 09:41:12Z

4

You can do something like

EXECUTE sqlq INTO target_variable;

for more help plpgsql-statements

answered Jul 11, 2014 at 9:41

Ilesh Patel

2,15516 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL: How to set value to variable using 'execute'?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related