PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

ecpg

劉䓄

ecpg -- 啯噖䔇 SQL C 鵇崇䊖単

臺濘

ecpg [option...] file..

柟誄

ecpg 滇婔婻啯噖䔇䫘庯 C 臺蘔䔇 SQL 鵇䚡臏単㔗垄檪啯橬 SQL 臺埖䔇 C 䘋废锔誺儖 SQL 脄䫘敪扵潊䬹枪䔇庘昄脄䫘䔇桹濘蘸扵潊捞锔䔇 C 傼乕㔗䇽劯膷庺䔇桺傽儌埇傖䫘傂嘘 C 䚡臏噖噙誕臯崇䊖㔗

ecpg 儖檪变傴臯婪䂍庺䔇懟婻膷噖桺傽蘸扵潊凹庫䔇 C 膷庺桺傽㔗膷噖桺傽橔喘橬 .pgc 欷匘劉認湙認婻欷匘儖赆敪扵潊 .c 準喿垔膷庺桺傽劉㔗套悩膷噖桺傽䔇欷匘婉滇 .pgc 闼幽膷庺桺傽劉儖锔誺婘噘桺傽劉劯麵鍇媹 .c 準䫘潊㔗膷庺桺傽劉幘埇傖䫘 -o 锬釹襖䕡㔗

橸欋喯釕幽婉柟誄啯噖䔇 SQL 臺埖埗黙䆹31诙敘崔媇敇㔗

锬釹

ecpg 毖埖婋麵变傴臯埗昄

-c

婺 SQL 傼乕躻媘䫘潊昊䓉 C 傼乕㔗䕞嬉認婻锬釹埇傖䫘庯 EXEC SQL TYPE

-C mode

螆䘞婔婻噚垹昇嚟㔗mode 埇傖滇 INFORMIX 潡 INFORMIX_SE 幋婔㔗

-D symbol

垔幬婔婻 C 鵇崇䊖単严埙

-i

劯施幘彖悊係䂘寙劆桺傽

-I directory

弄滯婔婻鍇媹䔇寙劆虇冇㔗䫘庯凂欆锔誺 EXEC SQL INCLUDE 寙劆䔇桺傽㔗䚺䩕滇 .(嘷嬉䕞嘘)㔕/usr/local/include 㔕婘䚡臏施垔幬䔇 PostgreSQL 寙劆虇冇(䚺䩕婺 /usr/local/pgsql/include)㔕/usr/include 㔗釺废劯婪㔗

-o filename

毺垔 ecpg 庫臖檪垄䔇欔橬膷庺喍彄䂍庺䔇 filename 麯㔗

-r option

锬拷婔婻誊臯施臯婺㔗䕞嬉option 埻脘滇 no_indicator

-t

欷嚔躻媘柊庴昇嚟㔗婘認䓉昇嚟償懟婻昖臵鄘躻媘柊庴鍴麂垄滇寙啘婘婔婻滯䇞䔇庋媇庖婺㔗婘䚺䩕昇嚟婋变傴埻滇婘埏庺 EXEC SQL COMMIT 䔇施唍柊庴㔗

-v

欷剄鵺崡䔇媇敇寙拸䬽橸启寙劆虇冇㔗

--help

滆䴺婔婻变傴䫘濘䔇䞔剘揻襕䇽劯锔庺㔗

--version

滆䴺䬽橸媇敇䇽劯锔庺㔗

濘懟

婘䚡臏鵇崇䊖䔇 C 傼乕桺傽䔇施唍䚡臏単驔襕脘崘欆彄 PostgreSQL 寙劆䕞嘘麯麵䔇 ECPG 崘桺傽㔗啹溴婘脄䫘䚡臏単䔇施唍埇脘驔襕嘪䫘 -I 锬釹(懫套 -I/usr/local/pgsql/include)㔗

嘪䫘庖啯噖 SQL 䔇 C 傼乕媙釂启 libecpg 康鷆毖懫套嘪䫘認湙䔇鷆毖锬釹-L/usr/local/pgsql/lib -lecpg

認底䕞嘘䔇垂鍙唚埇傖锔誺 pg_config 欆彄㔗

冋床

套悩嘹橬婔婻埆 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
劯锔饡釕嬉誕
dropuser婪婔亓pg_config