pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
sqlloader features 2+ messages / 2 participants [nested] [flat]
* sqlloader features @ 2004-03-12 09:05 azwa@nc.com.my 0 siblings, 1 reply; 2+ messages in thread From: azwa@nc.com.my @ 2004-03-12 09:05 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: sqlloader features @ 2004-03-12 14:55 Jeff Eckermann <jeff_eckermann@yahoo.com> parent: azwa@nc.com.my 0 siblings, 0 replies; 2+ messages in thread From: Jeff Eckermann @ 2004-03-12 14:55 UTC (permalink / raw) To: azwa@nc.com.my; pgsql-sql --- azwa@nc.com.my 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 youre looking for faster http://search.yahoo.com ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-03-12 14:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-03-12 09:05 sqlloader features azwa@nc.com.my 2004-03-12 14:55 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox