[linux] Ako dostat data z TXT do Postgresu

Pavol Lajciak Pavol.Lajciak na fedu.ku.sk
Středa Červen 2 14:20:52 CEST 2004


Prikaz COPY, uspesne som pouzival cez psql frontend.
Paulus

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' ] ]




Další informace o konferenci linux