#29 Change Prism::BulkPostgresChadoPrismDB.pm to use DBD::Pg

[daveriley]

Currently BulkPostgresChadoPrismDB uses a call to psql to do a COPY from the data file. This requires that the username/password be associated with a superuser as postgres does not allow copies from a file without superuser privileges.

An alternative could be to use the DBD::Pg database driver to do the copy.

http://search.cpan.org/dist/DBD-Pg/Pg.pm#COPY_support

details how this can be done. From what I can tell it uses a COPY FROM STDIN which should not require superuser privileges.