---
name: "SPI_gettype"
section: "3"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/SPI_gettype"
---

# SPI\_gettype(3)

return the data type name of the specified column

## NAME

SPI\_gettype - return the data type name of the specified column

## SYNOPSIS

```
char * SPI_gettype(TupleDesc rowdesc, int colnumber)
```

## DESCRIPTION

**SPI\_gettype** returns a copy of the data type name of the specified column. (You can use **pfree** to release the copy of the name when you don't need it anymore.)

## ARGUMENTS

TupleDesc *rowdesc*

input row description

int *colnumber*

column number (count starts at 1)

## RETURN VALUE

The data type name of the specified column, or NULL on error. *SPI\_result* is set to SPI\_ERROR\_NOATTRIBUTE on error.