DESCRIBE INPUT
Synopsis
DESCRIBE INPUT statement_name
Description
Lists the input parameters of a prepared statement along with the position and type of each parameter. Parameter types that cannot be determined will appear as unknown.
Examples
Prepare and describe a query with three parameters:
PREPARE my_select1 FROM
SELECT ? FROM nation WHERE regionkey = ? AND name < ?;
DESCRIBE INPUT my_select1;
Position | Type
--------------------
0 | unknown
1 | bigint
2 | varchar
(3 rows)
Prepare and describe a query with no parameters:
PREPARE my_select2 FROM
SELECT * FROM nation;
DESCRIBE INPUT my_select2;
Position | Type
-----------------
(0 rows)