dynamic-sql

65 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Dynamically cast type of array elements to match some expression type in PostgreSQL query
user_3388590
•
2
1
845
dynamic-sql postgresql arrays sql types
postgres function cannot see variable
user_18249690
•
1
1
129
postgresql-9.6 dynamic-sql plpgsql postgresql
What Identifier in "EXECUTE FORMAT" with "FOR ... IN" loop "record" variable/iterator that uses dot/period "." for Column name in PLPGSQL Procedure?
user_97969350
•
1
2
443
execute for-in-loop dynamic-sql plpgsql postgresql
Setting SQL Variable via Dynamic SQL
user_8369240
•
1
1
53
dynamic-sql sql-server sql variables
Dynamic SQL with EXECUTE and nested format()
user_97969350
•
1
2
303
dynamic-sql plpgsql common-table-expression postgresql
How to write a select query for displaying data on a table in another way using Postgresql?
user_165012710
•
1
2
95
crosstab dynamic-sql plpgsql join postgresql
In a SET assignment, can you use a variable to programmatically define the columnname that should be SET?
user_85342910
•
2
2
55
dynamic-sql postgresql sql
How secure is format() for dynamic queries inside a function?
user_159119680
•
2
2
211
dynamic-sql plpgsql sql-injection postgresql json
How to call DROP USER from pl/pgsql?
user_19808630
•
2
2
96
dynamic-sql plpgsql postgresql
quote_ident() does not add quotes to column name "first"
user_4333420
•
2
1
404
dynamic-sql identifier postgresql sql
Hot Questions