--- [EMAIL PROTECTED] wrote: > Hi , > > > does postgresql support for the sql loader > functionality like oracle > does ??? if no, is there any tools specific to do > this task connect to > postgresql database??? > i'm looking into open-source tools that can do > import & export facility. > thanks in advance
The PostgreSQL "COPY" command is very efficient at bulk loading, but has restrictive requirements as to the data formats that it will accept. I haven't tried this one, but it might work for you: http://gborg.postgresql.org/project/pgimport/projdisplay.php Otherwise your best alternative is probably to write a custom script using something like Perl, TCL, Awk or Sed to edit your data, which can then be piped to COPY. Something like: perlscript datafile | psql -c "copy table from stdin" database You can read about "COPY" in the "SQL Commands" section of the manual. > > __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
