[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