# PostgreSQL与i-Reporter协作项映射表

## 1. PostgreSQL->i-Reporter 协作

<table><thead><tr><th width="314">PostgreSQL字段类型</th><th>i-Reporter功能区类型</th></tr></thead><tbody><tr><td>・character</td><td><p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p></td></tr><tr><td><p>・character varying</p><p>・text</p></td><td><p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p><p>・条形码（仅限未勾选“作为数值”）</p><p>・扫码器</p><p>・主表选择</p></td></tr><tr><td><p>・bigint</p><p>・bigserial</p><p>・integer</p><p>・smallint</p><p>・serial</p><p>・decimal</p><p>・numeric</p><p>・double precision</p><p>・real</p><p>・money</p></td><td><p>・Keyboard<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・数值选择</p><p>・数值</p><p>・时间数</p><p>・确认</p><p>・单选</p><p>・多选</p><p>・条形码</p><p>・扫码器</p><p>・主表选择</p></td></tr><tr><td><p>・date</p><p>・timestamp</p></td><td><p>・Keyboard（Only None and Alphanumeric)<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・年月日</p><p>・日历</p></td></tr><tr><td><p>・bit</p><p>・bit varying</p><p>・time [ without time zone ]</p><p>・time [ with time zone ]</p><p>・boolean</p><p>・box</p><p>・bytea</p><p>・cidr</p><p>・circle</p><p>・inet</p><p>・interval</p><p>・line</p><p>・lseg</p><p>・macaddr</p><p>・path</p><p>・point</p><p>・polygon</p><p>・tsquery</p><p>・tsvector</p><p>・txid_snapshot</p><p>・uuid</p><p>・xml</p></td><td></td></tr></tbody></table>

## 2. i-Reporter→PostgreSQL 协作

| i-Reporter功能区类型                                                                                                                              | PostgreSQL字段类型                                                                                                                                                                                                                                                                                                                                            |
| -------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p>                                                | ・character                                                                                                                                                                                                                                                                                                                                                |
| <p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p><p>・条形码（仅限未勾选“作为数值”）</p><p>・扫码器</p><p>・主表选择</p> | <p>・character varying</p><p>・text</p>                                                                                                                                                                                                                                                                                                                     |
| <p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・数值选择</p><p>・数值</p><p>・时间数</p><p>・条形码</p>                                              | <p>・bigint</p><p>・bigserial</p><p>・integer</p><p>・smallint</p><p>・serial</p><p>・decimal</p><p>・numeric</p><p>・double precision</p><p>・real</p><p>・money</p>                                                                                                                                                                                               |
| <p>・年月日</p><p>・日历</p>                                                                                                                        | <p>・date</p><p>・timestamp</p>                                                                                                                                                                                                                                                                                                                             |
| 不支持                                                                                                                                          | <p>・bit</p><p>・bit varying</p><p>・time \[ without time zone ]</p><p>・time \[ with time zone ]</p><p>・boolean</p><p>・box</p><p>・bytea</p><p>・cidr</p><p>・circle</p><p>・inet</p><p>・interval</p><p>・line</p><p>・lseg</p><p>・macaddr</p><p>・path</p><p>・point</p><p>・polygon</p><p>・tsquery</p><p>・tsvector</p><p>・txid\_snapshot</p><p>・uuid</p><p>・xml</p> |

## 3. PostgreSQL->ConMas Gateway 实时集成 数据采集

<table><thead><tr><th width="287">SQL Serverフィールドの型</th><th>i-Reporterクラスターの種別</th></tr></thead><tbody><tr><td><p>・char</p><p>・varchar</p><p>・text</p><p>・nchar</p><p>・nvarchar</p><p>・ntext</p></td><td>・键盘文本（仅字母数字）。<br>※不支持自动编号模式。<br>・单个选择<br>・条形码（只有未选中时才作为数字处理）</td></tr><tr><td><p>・bigint</p><p>・int</p><p>・smallint</p><p>・tinyint</p><p>・decimal</p><p>・numeric</p><p>・float</p><p>・real</p></td><td>・键盘文本（仅限数字）。<br>※不支持自动编号模式。<br>※仅限数据采集菜单。<br>・校验。<br>・条形码（只有不带校验的条形码才被视为数字）。<br>※仅支持数据采集菜单。</td></tr><tr><td>・bit</td><td>・校验。</td></tr><tr><td><p>・money</p><p>・smallmoney</p></td><td><p>・キーボードテキスト(Numberのみ)</p><p>※自動採番モードには対応していません。</p><p>※データ取得メニューのみ ・数値</p></td></tr><tr><td><p>・date</p><p>・datetime</p><p>・datetime2</p><p>・smalldatetime</p><p>・datetimeoffset</p></td><td>未対応</td></tr><tr><td><p>・time</p><p>※タイムゾーン対応無し</p></td><td>未対応</td></tr><tr><td><p>・binary</p><p>・varbinary</p></td><td>未対応</td></tr></tbody></table>

## 4. SQL Server->ConMas Gateway 实时集成 主数据采集

|   |   |   |
| - | - | - |
|   |   |   |
|   |   |   |
|   |   |   |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://cimtops.gitbook.io/i-repo-link-manual/chinese/shu-ju-yuan-xie-zuo-suo-you-shu-ju-ku-gong-tong/gong-tong/postgresql-yu-ireporter-xie-zuo-xiang-ying-she-biao.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.