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)

See Also

PREPARE