PostgreSQL

PostgreSQL Elephant Logo

46.2. Interface Support Functions

SPI_fname — determine the column name for the specified column number

SPI_fnumber — determine the column number for the specified column name

SPI_getvalue — return the string value of the specified column

SPI_getbinval — return the binary value of the specified column

SPI_gettype — return the data type name of the specified column

SPI_gettypeid — return the data type OID of the specified column

SPI_getrelname — return the name of the specified relation

SPI_getnspname — return the namespace of the specified relation

The functions described here provide an interface for extracting information from result sets returned by SPI_execute and other SPI functions.

All functions described in this section can be used by both connected and unconnected procedures.


Prev Up Next

SPI_register_trigger_data

Home

SPI_fname

Copyright © 1996-2023 The PostgreSQL Global Development Group