COPY
目录
COPY
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
FILE FORMATS æä»¶æ ¼å¼
TEXT FORMAT ææ¬æ ¼å¼
BINARY FORMAT äºè¿å¶æ ¼å¼
FILE HEADER æ件头
TUPLES åç»
FILE TRAILER æ件尾
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·
NAME
COPY - å¨è¡¨åæ件ä¹é´æ·è´æ°æ®
SYNOPSIS
COPY
tablename [ ( column [, ...] ) ]
FROM { ’filename’ | STDIN }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] ’delimiter’ ]
[ NULL [ AS ] ’null string’ ] ]
COPY
tablename [ ( column [, ...] ) ]
TO { ’filename’ | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] ’delimiter’ ]
[ NULL [ AS ] ’null string’ ] ]
DESCRIPTION æè¿°
COPY å¨ PostgreSQL表åæ åæ件系ç»æ件ä¹é´äº¤æ¢æ°æ®ã COPY TO æä¸ä¸ªè¡¨çææå容é½æ·è´å°ä¸ä¸ªæä»¶ï¼ è COPY FROM ä»ä¸ä¸ªæ件éæ·è´æ°æ®å°ä¸ä¸ªè¡¨éï¼ææ°æ®éå å°è¡¨ä¸å·²ç»åå¨çå容éï¼ã
å¦æ声æäºä¸ä¸ªå段å表ï¼COPY å°åªå¨æ件å表ä¹é´æ·è´å£°æçå段çæ°æ®ã å¦æ表ä¸æä»»ä½ä¸å¨å段å表éçå段ï¼é£ä¹ COPY FROM å°ä¸ºé£äºå- 段æå¥ç¼ºçå¼ã
带æ件åç COPY æ示 PostgreSQL æå¡å¨ç´æ¥ä»æ件ä¸è¯»åæ°æ®ã å¦æ声æäºæ件åï¼é£ä¹è¯¥æ件å¿é¡»ä¸ºæå¡å¨å¯è§ï¼èä¸æ件åå¿é¡»ä»æå¡å¨çè§åº¦å£°æãå¦æ声æçæ¯ STDIN æ STDOUTï¼æ°æ®éè¿è¿æ¥å¨å®¢æ·å端åæå¡å¨ä¹é´æµå¨ã
PARAMETERS åæ°
tablename
ç°å表çååï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ã
|
column |
å¯éçå¾æ·è´å段å表ãå¦æ没æ声æå段å表ï¼é£ä¹å°ä½¿ç¨ææå段ã
filename
è¾å¥æè¾åºæ件çç»å¯¹è·¯å¾åã
|
STDIN |
声æè¾å¥æ¯æ¥èªå®¢æ·ç«¯åºç¨ã
|
STDOUT |
声æè¾å¥åå¾å®¢æ·ç«¯åºç¨ã
|
BINARY |
使ç¨äºè¿å¶æ ¼å¼åå¨å读åï¼èä¸æ¯ä»¥ææ¬çæ¹å¼ã å¨äºè¿å¶æ¨¡å¼ä¸ï¼ä¸è½å£°æ DELIMITERSåNULLã
|
OIDS |
声æ为æ¯è¡æ·è´åé¨å¯¹è±¡æ è¯ï¼OIDï¼ã ï¼å¦æç»é£äºæ²¡æ OID ç表声æäº OIDS é项ï¼åæåºä¸ä¸ªé误ãï¼
delimiter
ç¨äºå¨æ件ä¸æ¯è¡ä¸åéå个å段çå个å符ã 缺çæ¯æ°´å¹³å¶è¡¨ç¬¦ãï¼tabï¼
null string
ä¸ä¸ªä»£è¡¨ NULL å¼çå串ã缺çæ¯ \N ï¼åææ -Nï¼ã å½ç¶ï¼ä½ å¯ä»¥èªå·±æä¸ä¸ªç©ºå串ã
Note: 注æ: 对äºCOPY FROMï¼ä»»ä½å¹éè¿ä¸ªå串çå串å°è¢«åå¨ä¸º NULL å¼ï¼ æä»¥ä½ åºè¯¥ç¡®ä¿ä½ ç¨çå串åCOPY TOç¸åã
NOTES 注æ
COPY åªè½ç¨äºè¡¨ï¼ä¸è½ç¨äºè§å¾ã
BINARY å³é®åå°å¼ºå¶ä½¿ç¨äºè¿å¶å¯¹è±¡èä¸æ¯ææ¬åå¨/读åæææ°æ®ã è¿æ·åå¨ä¸å®ç¨åº¦ä¸æ¯ä¼ç»çæ·è´å½ä»¤å¿«ï¼ä½äºè¿å¶æ·è´æ件å¨ä¸åæºå¨ä½ç³»é´çæ¤æ§ä¸æ¯å¾å¥½ã
ä½ å¯¹ä»»ä½è¦COPY TO åºæ¥çæ°æ®å¿é¡»æéåæ°æ®çæéï¼å¯¹ä»»ä½è¦ COPY FROM å¥æ°æ®ç表å¿é¡»ææå¥æéã
COPY å½ä»¤éé¢çæ件å¿é¡»æ¯ç±æå¡å¨ç´æ¥è¯»æåçæ件ï¼èä¸æ¯ç±å®¢æ·ç«¯åºç¨è¯»åã å æ- ¤ï¼å®ä»¬å¿é¡»ä½äºæ°æ®åºæå¡å¨ä¸æèå¯ä»¥ä¸ºæ°æ®åºæå¡å¨æ访é®ï¼èä¸æ¯ç±å®¢æ·ç«¯åè¿äºäºæã å®ä»¬å¿é¡»æ¯PostgreSQLç¨æ·ï¼æå¡å¨è¿è¡çç¨æ· IDï¼å¯ä»¥è®¿é®å°å¹¶ä¸å¯è¯»æèå¯åï¼èä¸æ¯å®¢æ·ç«¯ã COPY å°ä¸ä¸ªå½åæ件æ¯åªå许æ°æ®åºè¶çº§ç¨æ·è¿è¡çï¼å为å®å许读åä»»ææå¡å¨ææé访é®çæ件ã
ä¸è¦æ··æ· COPY å psql æ令 \copyã \copy è°ç¨ COPY FROM STDIN æè COPY TO STDOUTï¼ ç¶åææ°æ®æå/åå¨å°ä¸ä¸ª psql 客æ·ç«¯å¯ä»¥è®¿é®çæ件ä¸ã å æ- ¤ï¼ä½¿ç¨ \copy çæ¶åï¼æ件访é®æéæ¯ç±å®¢æ·ç«¯èä¸æ¯æå¡å¨ç«¯å³å®çã
æä»¬å»ºè®®å¨ COPY éçæ件ååæ»æ¯ä½¿ç¨ç»å¯¹è·¯å¾ã å¨ COPY TO çæ¶åæ¯ç±æå¡å¨å¼ºå¶è¿è¡çï¼ ä½æ¯å¯¹äº COPY FROMï¼ä½ çç¡®æä»ä¸ä¸ªå£°æ为ç¸å¯¹è·¯å¾çæ件é读åçéæ©ã 该路å¾å°è§£é为ç¸å¯¹äºæå¡å¨çå·¥ä½ç®å½ï¼å¨æ°æ®ç®å½éçä»ä¹å°æ¹ï¼ï¼èä¸æ¯å®¢æ·ç«¯çå·¥ä½ç®å½ã
COPY FROM ä¼æ¿æ´»ææ触åå¨åæ£æ¥çº¦æãä¸è¿ï¼ä¸ä¼æ¿æ´»è§åã
COPY å¨ç¬¬ä¸ä¸ªé误å¤åä¸æ¥ãè¿äºå¨ COPY TOä¸ä¸åºè¯¥å¯¼è´é®é¢ï¼ ä½å¨ COPY FROM æ¶ç®ç表ä¼å·²ç»æ¥æ¶å°æ©åçè¡ï¼ è¿äºè¡å°ä¸å¯è§æä¸å¯è®¿é®ï¼ä½æ¯ä»ç¶ä¼å æ®ç£ç空é´ã å¦æä½ ç¢°å·§æ¯æ·è´å¾å¤§ä¸åæ°æ®æ件çè¯ï¼ 积累起æ¥ï¼è¿äºä¸è¥¿å¯è½ä¼å æ®ç¸å½å¤§çä¸é¨åç£ç空é´ãä½ å¯ä»¥è°ç¨ VACUUM æ¥æ¢å¤é£äºç£ç空é´ã
FILE FORMATS æä»¶æ ¼å¼
TEXT FORMAT ææ¬æ ¼å¼
å½ä¸å¸¦ BINARY éé¡¹ä½¿ç¨ COPY æ¶ï¼ 读åçæ件æ¯ä¸ä¸ªææ¬æ件ï¼æ¯è¡ä»£è¡¨è¡¨ä¸ä¸ä¸ªè¡ã è¡ä¸çåï¼å- 段ï¼ç¨åé符åå¼ã å段å¼æ¬èº«æ¯ç±ä¸æ¯ä¸ªå段类åç¸å³çè¾åºå½æ°çæçå- ç¬¦ä¸²ï¼ æèæ¯è¾å¥å½æ°å¯æ¥åçå串ã æ°æ®ä¸ä½¿ç¨ç¹å®ç空å¼å串表示é£äºä¸º NULL çå段ã å¦æè¾å¥æ件çä»»æè¡åå«æ¯é¢æå¤æèå°çå段ï¼é£ä¹ COPY FROM å°æåºä¸ä¸ªé误ã å¦æ声æäº OIDSï¼é£ä¹ OID å°ä½ä¸ºç¬¬ä¸ä¸ªå段读åï¼ æ¾å¨ææç¨æ·å段åé¢ã
æ°æ®çç»æå¯ä»¥ç¨ä¸ä¸ªåªåå«åææåå¥ç¹ï¼\.ï¼çè¡è¡¨ç¤ºã å¦æä»æ件ä¸- 读åæ°æ®ï¼é£ä¹æ°æ®ç»æçæ è®°æ¯ä¸å¿è¦çï¼ å 为æ件ç»æèµ·çä½ç¨å°±å¾å¥½äºï¼ä½æ¯å¨ 3.0 ä¹åç客æ·ç«¯åè®®éï¼å¦æå¨å®¢æ·ç«¯åºç¨ä¹é´æ·è´æ°æ®ï¼ é£ä¹å¿é¡»è¦æç»ææ è®°ã
åææå符ï¼\ï¼å¯ä»¥ç¨å¨ COPY éç»é£äºä¼ææ§ä¹çå符è¿è¡éé¸ï¼å¦åé£äºå- 符ä¼è¢«å½åè¡æèå段åé符å¤çï¼ã ç¹å«æ¯ä¸é¢çå符å¦ææ¯å- 段å¼çä¸é¨åæ¶ï¼å¿é¡»åç¼ä¸ä¸ªåææï¼åæææ¬èº«ï¼æ¢è¡ç¬¦ï¼å车ï¼ä»¥åå½ååé符ã
声æç空å串被 COPY TO ä¸å ä»»ä½åææ åéï¼ä¸ä¹ç¸å¯¹ï¼COPY FROM å¨å é¤åææ ä¹åæ¿å®çè¾å¥ä¸ç©ºå串æ¯è¾ãå æ¤ï¼å \N è¿æ ·ç空å- 串ä¸ä¼åå®éæ°æ®å¼ \N ä¹é´æ··æ·ï¼å 为åèä¼è¡¨ç°æ \\Nï¼ã
COPY FROM è¯å«ä¸åç¹æ®åææåºåï¼
\b éæ ¼ (ASCII 8)
\f è¿çº¸ (ASCII 12)
\n æ°è¡ (ASCII 10)
\r å车 (ASCII 13)
\t è·³æ ¼ (ASCII 9)
\v ç«ç´è·³æ ¼ (ASCII 11)
\digits (åææ ï¼åé¢æ¯ä¸ä¸ªå«è¿å¶æ°å¼ï¼ä»£è¡¨å·ææå®å¼çå符)
ç®åï¼COPY TO å°ç»ä¸ä¼ååºä¸ä¸ªå«è¿å¶åææåºåï¼ ä½æ¯å®ç确使ç¨äºä¸é¢ååºçå¶å®å符ç¨äºæ§å¶å符ã
ç»å¯¹ä¸è¦æåæææ¾å¨ä¸ä¸ªæ°æ®å符Næèå¥ç¹ï¼.ï¼åé¢ã è¿æ ·çç»åå°åå«è¢«è¯¯è®¤ä¸ºæ¯ç©ºå串(\.) æèæ°æ®ç»ææ è®° (\N)ã å¦å¤ä¸ä¸ªæ²¡æå¨ä¸é¢ç表ä¸ååºçåææå符就æ¯å®èªå·±ã
æ们强ç建议çæ COPY æ°æ®çåºç¨å«æ¢è¡ç¬¦åå车åå«è½¬æ¢æ \n å \r åºåã ç®åæ们å¯ä»¥ç¨ä¸ä¸ªåææåä¸ä¸ªå车表示ä¸ä¸ªæ°æ®å车ï¼ä»¥åç¨ä¸ä¸ªåææåä¸ä¸ªæ¢è¡ç¬¦è¡¨ç¤ºä¸ä¸ªæ°æ®æ¢è¡ç¬¦ã ä¸è¿ï¼è¿æ ·ç表示å¨å°æ¥ççæ¬ä¸ç¼ºçæ¶å¯è½ä¸ä¼è¢«æ¥åã
They are also highly vulnerable to corruption if the COPY file is transferred across different machines (for example, from Unix to Windows or vice versa).
COPY TO å°åæ¯è¡çç»å°¾æ¯ç¨ä¸ä¸ª Unix é£æ ¼çæ¢è¡ç¬¦("\n")ï¼ æèæ¯å¨ MS Windows ä¸è¿è¡çæå¡å¨ä¸ç¨ï¼"\r\n"ï¼æ è®°ä¸è¡ç»æ- ¢ï¼ä½åªæ¯ç¨äºCOPYå°æå¡å¨æ件éï¼ ä¸ºäºå¨ä¸åå¹³å°ä¹é´ä¸è´ï¼COPY TO STDOUT æ»æ¯åé "\n"ï¼ä¸ç®¡æå¡å¨å¹³å°æ¯ä»ä¹ã COPY FROM å¯ä»¥å¤çé£äºä»¥å车符ï¼æèæ¢è¡ç¬¦ï¼æèå车æ¢è¡ç¬¦ä½ä¸ºè¡ç»æçæ°æ®ã 为äºåå°å¨æ°æ®ä¸- åºç°çæªéé¸çæ°è¡æèå车导è´çé误ï¼å¦æè¾å¥çè¡ç»å°¾ä¸åä¸é¢è¿äºç¬¦å·ï¼ COPY FROM ä¼ååºè¦åã
BINARY FORMAT äºè¿å¶æ ¼å¼
å¨PostgreSQL 7.4 ä¸ç COPY BINARY çæä»¶æ ¼å¼åäºååãæ°æ ¼å¼ç±ä¸ä¸ªæ件头ï¼é¶æå¤æ¡åç»ï¼ 以åæ件尾ç»æãæ件头åæ°æ®ç°å¨æ¯ç½ç»åèåºã
FILE HEADER æ件头
æ件头ç±
15
个åèçåºå®åç»æï¼åé¢è·çä¸ä¸ªåé¿ç头æ©å±åºã
åºå®åæ¯ï¼
Signature ç¾å
11-åèçåºå PGCOPY\n\377\r\n\0 --- 请注æåèé¶æ¯ç¾åæ¯è¦æ±çä¸é¨åã ï¼ä½¿ç¨è¿ä¸ªç¾åæ¯ä¸ºäºè®©æ们è½å¤å¾å®¹æçåºæ件æ¯å¦å·²ç»è¢«ä¸ä¸ªé 8 ä½å®å¨ç转æ¢å¨ç»ç³è¹äºã è¿ä¸ªç- ¾åä¼è¢«è¡ç»å°¾è½¬æ¢è¿æ»¤å¨ï¼å é¤å- èé¶ï¼å é¤é«ä½ï¼æèå¥å¶çæ¹åèæ¹åãï¼
Flags field æ å¿å
32 ä½æ´æ°æ©ç 表示该æä»¶æ ¼å¼çéè¦æ¹é¢ã ä½æ¯ä» 0ï¼LSBï¼å° 31 ï¼MSBï¼ç¼ç ç --- 请注æè¿ä¸ªåæ¯ä»¥ç½ç»åèåºåå¨çï¼é«ä½å¨åï¼ï¼ å继çæ´æ°é½æ¯å¦æ¤ãä½ 16 - 31 æ¯ä¿çç¨åå³é®æä»¶æ ¼å¼ä¿¡æ¯çï¼ å¦æ读èåç°ä¸ä¸ªä¸è®¤è¯çä½åºç°å¨è¿ä¸ªèå´åï¼é£ä¹å®åºè¯¥éåºã ä½ 0-15 é½ä¿ç为æå¿ååå¼å®¹çæ¼å¼ä½¿ç¨ï¼è¯»èå¯ä»¥å¿½ç¥è¿ä¸ªèå´åçä¸è®¤è¯çä½ãç®ååªå®ä¹äºä¸ä¸ªæå¿ä½ï¼èå¶å®çå¿é¡»æ¯é¶ï¼
|
Bit 16 |
å¦æ为 1ï¼é£ä¹å¨æ°æ®ä¸åæ¬äº OIDï¼å¦æ为 0ï¼å没æ
头æ©å±èå´é¿åº¦
32 ä½æ´æ°ï¼ä»¥åè计ç头å©ä½é¿åº¦ï¼ä¸åæ¬èªèº«ãç®åï¼å®æ¯é¶ï¼ åé¢ç´§è·ç¬¬ä¸æ¡åç»ã对该æ¼å¼çæ´å¤çä¿®æ¹é½å°å许é¢å¤çæ°æ®åºç°å¨å¤´ä¸- ã 读èåºè¯¥å¿½ç¥ä»»ä½å®ä¸ç¥é该å¦ä½å¤çç头æ©å±æ°æ®ã
头æ©å±æ°æ®æ¯ä¸ä¸ªç¨æ¥ä¿çä¸ä¸ªèªå®ä¹çæ°æ®åºååç¨çãè¿ä¸ªæå¿åææåè¯è¯»èæ©å±åºçå容æ¯ä»ä¹ã头æ©å±çå·ä½è®¾è®¡å容çç»ä»¥åççæ¬ç¨ã
è¿æ·è®¾è®¡å°±å许åä¸å¼å®¹å¤´éåï¼å¢å头æ©å±åï¼æè设置ä½ä½åºæå¿ä½ï¼ä»¥åéåä¸å¼å®¹ä¿®æ¹ï¼è®¾ç½®é«ä½æå¿ä½ä»¥æè¯è¿æ·çä¿®æ¹ï¼ 并ä¸æ ¹æ®éè¦åæ©å±åºåå¢å æ¯ææ°æ®ï¼ã
TUPLES åç»
æ¯æ¡åç»é½ä»¥ä¸ä¸ª 16 ä½æ´æ°è®¡æ°å¼å¤´ï¼è¯¥è®¡æ°æ¯åç»ä¸å- 段çæ°ç®ãï¼ç®åï¼å¨ä¸ä¸ªè¡¨éçæ¯æ¡åç»é½æç¸åç计æ°ï¼ä½å¯è½ä¸ä¼æ°¸è¿è¿æ·ãï¼ç¶ååé¢ä¸æ- åºç°åç»ä¸çå个å段ï¼å段åæ¯ä¸ä¸ª 32 ä½çé¿åº¦åï¼åé¢è·çé£ä¹é¿çå- 段æ°æ®ãï¼é¿åº¦å并ä¸åæ¬èªå·±ï¼å¹¶ä¸å¯ä»¥ä¸ºé¶ãï¼ä¸ä¸ªç¹ä¾æ¯ï¼-1 表示ä¸ä¸ª NULL å段å¼ãå¨ NULL æåµä¸ï¼åé¢ä¸ä¼è·çæ°å¼åèã
å¨æ°æ®åä¹é´æ²¡æ对å¥å¡«åæèä»»ä½å¶å®é¢å¤çæ°æ®ã
ç®åï¼ä¸ä¸ª COPY BINARY æ件éçæææ°æ®å¼é½å设æ¯äºè¿å¶æ¼å¼çï¼æ¼å¼ä»£ç为ä¸ï¼ãé¢è®¡å°æ¥çæ©å±å¯è½å¢åä¸ä¸ªå¤´åï¼å许为æ¯ä¸ªå- 段声ææ ¼å¼ä»£ç ã
为äºå¤æå®éåç»æ°æ®çæ£ç¡®çäºè¿å¶æ ¼å¼ï¼ä½ åºè¯¥é读 PostgreSQL æºä»£ç ï¼ç¹å«æ¯è¯¥å段æ°æ®ç±»åç *send å *recv å½æ°ï¼å¸åçå½æ°å¯ä»¥å¨æºä»£ç ç src/backend/utils/adt/ ç®å½æ¾å°ï¼ã
å¦æå¨æ件ä¸åæ¬äº OIDï¼é£ä¹è¯¥ OID åç«å³è·å¨å段计æ°å- åé¢ãå®æ¯ä¸ä¸ªæ®éçå段ï¼åªä¸è¿å®æ²¡æåæ¬å¨å段计æ°ãä½å®åæ¬é¿åº¦å --- è¿æ ·å°±å许æ们ä¸ç¨è±å¤ªå¤çå²å°±å¯ä»¥å¤ç 4 åèå 8 åèç OIDï¼å¹¶ä¸å¦ææ个家ä¼å许 OID æ¯å¯éçè¯ï¼é£ä¹è¿å¯ä»¥æ OID æ¾ç¤ºæ空ã
FILE TRAILER æ件尾
æ件尾åæ¬ä¿åç -1 çä¸ä¸ª 16 ä½æ´æ°åãè¿æ ·å°±å¾å®¹æä¸ä¸æ¡åç»çå计æ°å- ç¸åºåã
å¦æä¸ä¸ªå计æ°åæ¢ä¸æ¯ -1 ä¹ä¸æ¯é¢æçå段çæ°ç®ï¼é£ä¹è¯»èåºè¯¥æ¥éã è¿æ ·å°±æä¾äºå¯¹ä¸¢å¤±ä¸æ°æ®çåæ¥çé¢å¤çæ£æ¥ã
EXAMPLES ä¾å
ä¸é¢çä¾åæä¸ä¸ªè¡¨æ·è´å°å®¢æ·ç«¯ï¼ 使ç¨ç«ç´æ¡ï¼|ï¼ä½ä¸ºååé符ï¼
COPY country TO STDOUT WITH DELIMITER ’|’;
ä»ä¸ä¸ª Unix æ件ä¸æ·è´æ°æ®å°ä¸ä¸ªcountry表ä¸ï¼
COPY country FROM ’/usr1/proj/bray/sql/country_data’;
ä¸é¢æ¯ä¸ä¸ªå¯ä»¥ä» STDIN ä¸æ·è´æ°æ®å°è¡¨ä¸çä¾åï¼
AF AFGHANISTAN
AL ALBANIA
DZ ALGERIA
ZM ZAMBIA
ZW ZIMBABWE
请注æå¨è¿éæ¯è¡éç空ç½å®éä¸æ¯ä¸ä¸ªæ°´å¹³å¶è¡¨ç¬¦ tabã
ä¸é¢çæ¯åæ ·çæ°æ®ï¼å¨ä¸å° Linux/i586 æºå¨ä¸ä»¥äºè¿å¶å½¢å¼è¾åºã è¿äºæ°æ®æ¯ç¨ Unix å·¥å· od -c è¿æ»¤ä¹åè¾åºçã 该表æä¸ä¸ªå- 段ï¼ç¬¬ä¸ä¸ªæ¯ char(2)ï¼ ç¬¬äºä¸ªæ¯ textï¼ ç¬¬ä¸ä¸ªæ¯integerãææçè¡å¨ç¬¬ä¸ä¸ªåé½æ¯ä¸ä¸ª null å¼ã
0000000 P G C O
P Y \n 377 \r \n \0 \0 \0 \0 \0 \0
0000020 \0 \0 \0 \0 003 \0 \0 \0 002 A F \0 \0 \0 013 A
0000040 F G H A N I S T A N 377 377 377 377 \0 003
0000060 \0 \0 \0 002 A L \0 \0 \0 007 A L B A N I
0000100 A 377 377 377 377 \0 003 \0 \0 \0 002 D Z \0 \0 \0
0000120 007 A L G E R I A 377 377 377 377 \0 003 \0 \0
0000140 \0 002 Z M \0 \0 \0 006 Z A M B I A 377 377
0000160 377 377 \0 003 \0 \0 \0 002 Z W \0 \0 \0 \b Z I
0000200 M B A B W E 377 377 377 377 377 377
COMPATIBILITY å¼å®¹æ§
å¨ SQL æ åé没æ COPY è¯å¥ã
7.3 以åçåºç¨ä½¿ç¨ä¸é¢çè¯æ³ï¼ç°å¨ä»ç¶æ¯æï¼
COPY [ BINARY ]
tablename [ WITH OIDS ]
FROM { ’filename’ | STDIN }
[ [USING] DELIMITERS ’delimiter’ ]
[ WITH NULL AS ’null string’ ]
COPY [ BINARY ]
tablename [ WITH OIDS ]
TO { ’filename’ | STDOUT }
[ [USING] DELIMITERS ’delimiter’ ]
[ WITH NULL AS ’null string’ ]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh