17.13. DESCRIBE INPUT
Synopsis
DESCRIBE INPUT statement_name
Description
Describes the input parameters for a prepared statement. It returns a table with the position and type of each parameter. If the type of the parameter can not be determined, unknown is returned.
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)