---
title: "SPI_gettypeid"
id: spi-spi-gettypeid
pg_version: "20devel"
---

<a id="spi-spi-gettypeid"></a>

# SPI_gettypeid — return the data type OID of the specified column

## Synopsis

```
Oid SPI_gettypeid(TupleDesc rowdesc, int colnumber)
```

<a id="id-1.8.12.9.9.5"></a>

## Description

`SPI_gettypeid` returns the OID of the data type of the specified column. 

<a id="id-1.8.12.9.9.6"></a>

## Arguments

**`TupleDesc rowdesc`**

 input row description **`int colnumber`**

 column number (count starts at 1) <a id="id-1.8.12.9.9.7"></a>

## Return Value

The OID of the data type of the specified column or `InvalidOid` on error. On error, `SPI_result` is set to `SPI_ERROR_NOATTRIBUTE`.