https://postgrespro.ru/docs/postgrespro/16/ecpg-variables#ECPG-VARIABLES-TYPE-MAPPING
| Тип данных Postgres Pro | Тип переменной среды С |
|---|---|
| smallint | short |
| integer | int |
| bigint | long long int |
| decimal | decimal[a] |
| numeric | numeric[a] |
| real | float |
| double precision | double |
| smallserial | short |
| serial | int |
| bigserial | long long int |
| oid | unsigned int |
| character(n), varchar(n), text | char[n+1], VARCHAR[n+1] |
| name | char[NAMEDATALEN] |
| timestamp | timestamp[a] |
| interval | interval[a] |
| date | date[a] |
| boolean | bool[b] |
| bytea | char *, bytea[n] |