Overview

DESCRIBE INPUT statement_name

Description

Lists the parameters of a precompiled query statement and the position and type of each parameter.

Examples

--- Create a precompiled query statement 'my_ select1'
PREPARE my_select1 FROM
SELECT ? FROM nation WHERE regionkey = ? AND name < ? ;

--- Get the descriptive information about the precompiled statement
DESCRIBE INPUT my_select1;
Query results:
Position | Type
--------------------
        0 | unknown
        1 | bigint
        2 | varchar
(3 rows)