DESCRIBE INPUT

Synopsis

  1. 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:

  1. PREPARE my_select1 FROM
  2. SELECT ? FROM nation WHERE regionkey = ? AND name < ?;
  1. DESCRIBE INPUT my_select1;
  1. Position | Type
  2. --------------------
  3.        0 | unknown
  4.        1 | bigint
  5.        2 | varchar
  6. (3 rows)

Prepare and describe a query with no parameters:

  1. PREPARE my_select2 FROM
  2. SELECT * FROM nation;
  1. DESCRIBE INPUT my_select2;
  1. Position | Type
  2. -----------------
  3. (0 rows)

See Also

prepare