I need to write an import function with enough isolation from apache
daemon.
Code has no input other than cvs files and a signal about when to
start the import.
The sql code that will be executed will be static.
I may end up writing a mini-daemon that just start a SQL script or
just pool from cron and feed psql.
If anyone has a better (lazier, cleaner) approach it will be very
welcome.
copy from file need superuser right. I'd like to avoid it.
copy from stdin looks just as a burden on me as a programmer.
\copy seems to be what I'm looking for.
Can I use \copy inside a transaction and is it going to be rolled
back if something goes wrong?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it