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 */ ```

Accepted Answer

You can do something like

```
EXECUTE sqlq INTO target_variable;
```

for more help plpgsql-statements

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

Solution

Problem