ECPG

NAME
SYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
NOTES 注æ
EXAMPLES ä¾å
è¯è
è·

---

NAME

ecpg - åµå¥ç SQL C é¢å¤çå¨

SYNOPSIS

ecpg [ option... ] file...

DESCRIPTION æè¿°

ecpg æ¯ä¸ä¸ªåµå¥çç¨äºC è¯è¨ç SQL é¢ç¼è¯å¨ã å®æåµæ SQL è¯å¥ç C ç¨åºéè¿å° SQL è°ç¨æ¿æ¢æç¹æ®çå½æ°è°ç¨çæ¹æ³è½¬æ¢ææ®éç C 代ç ã ç¶åè¾åºçæ件就å¯ä»¥ç¨ä»»ä½ C ç¼è¯å·¥å·è¿è¡å¤çã

clusterdb å°æå½ä»¤è¡ä¸ç»åºçæ¯ä¸ªè¾å¥æ件转æ¢æ对åºç C è¾åºæ件ã è¾å¥æ件æ好æ .pgc çæ©å±åï¼ è¿æ ·ï¼è¿ä¸ªæ©å±å°è¢«æ¿æ¢æ .c æ¥å³å®è¾åºæ件åã å¦æè¾å¥æ件çæ©å±ä¸æ¯ .pgcï¼é£ä¹è¾åºæ件åå°éè¿å¨å¨æ件ååé¢éå  .c æ¥çæã è¾åºæ件åä¹å¯ä»¥ç¨ -o é项è¦çã

æ¬æå页并ä¸æè¿°åµå¥ç SQL è¯å¥ï¼åé Chapter 29 è·æ´å¤ä¿¡æ¯ã

OPTIONS é项

clusterdb æ¥åä¸åå½ä»¤è¡åæ°ï¼

-c

为 SQL 代ç èªå¨çææç§ C 代ç ãç®åï¼è¿ä¸ªé项å¯ä»¥ç¨äº EXEC SQL TYPEã

-C mode

设置ä¸ä¸ªå¼å®¹æ¨¡å¼ãmode å¯ä»¥æ¯ INFORMIX æè INFORMIX_SEã

-D symbol

å®ä¹ä¸ä¸ª C é¢ç¼è¯å¨ç¬¦å·ã

-i

åæ¶ä¹åæç³»ç»åå«æ件ã

-I include-path

声æä¸ä¸ªéå çåå«è·¯å¾ãç¨äºå¯»æ¾éè¿ EXEC SQL INCLUDE åå«çæ件ã缺çæ¯ .ï¼å½åç®å½ï¼ï¼ /usr/local/includeï¼ å¨ç¼è¯æ¶å®ä¹çPostgreSQL åå«è·¯å¾ï¼ç¼ºçï¼ /usr/local/pgsql/includeï¼å /usr/includeã顺åºå¦ä¸ã

-o filename

声æecpgåºè¯¥æå®çææè¾åºåå°ç»åºç filenameéã

-t

æå¼èªå¨æ交模å¼ãå¨è¿ç§æ¨¡å¼è±¡ï¼æ¯ä¸ªæ¥è¯¢é½èªå¨æäº¤ï¼ é¤éå®æ¯åå´å¨ä¸ä¸ªæç¡®çäºå¡åä¸ãå¨ç¼ºç模å¼ä¸ï¼ å½ä»¤åªæ¯å¨ååº EXEC SQL COMMIT çæ¶åæ交ã

-v

æå°é¢å¤çä¿¡æ¯ï¼åæ¬çæ¬ååå«è·¯å¾ã

--help

æ¾ç¤ºä¸ä¸ªå½ä»¤ç¨æ³çç®åæè¦ï¼ç¶åéåºã

--version

æ¾ç¤ºçæ¬ä¿¡æ¯ï¼ç¶åéåºã

NOTES 注æ

å¨ç¼è¯é¢å¤çç C 代ç æ件çæ¶åï¼ç¼è¯å¨éè¦è½å¤æ¾å° PostgreSQL åå«ç®å½éé¢ç ECPG 头æ件ãå æ¤ï¼æ们å¨è°ç¨ç¼è¯å¨çæ¶åå¯è½éè¦ä½¿ç¨ -I ï¼æ¯å¦ï¼-I/usr/local/pgsql/includeï¼ã
使ç¨äºåµå¥ SQL ç C 代ç å¿é¡»å libecpg åºé¾æ¥ï¼æ¯å¦ï¼ä½¿ç¨è¿æ ·çé¾æ¥éé¡¹ï¼ -L/usr/local/pgsql/lib -lecpg
è¿äºç®å½çå®éå¼å¯ä»¥éè¿ pg_config(1) æ¾å°ã

EXAMPLES ä¾å

å¦æä½ æä¸ä¸ªå« prog1.pgc çåµå¥ SQL ç C æºä»£ç ï¼ä½ å¯ä»¥ç¨ä¸é¢çå½ä»¤åºåå建ä¸ä¸ªå¯æ§è¡ç¨åºï¼

ecpg prog1.pgc
cc -I/usr/local/pgsql/include -c prog1.c
cc -o prog1 prog1.o -L/usr/local/pgsql/lib -lecpg

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---