https://community.qlik.com/t5/Talend-Studio/Postgresql-bulk-import-copy/m-p/2357223#M122572 You can find following screenshots :<BR />? job Talend using bulk component : <BR />o tpostgresqlOuputBulk : generate file<BR />o tpostgresqlOuputBulkExec : integrate file<BR />? properties of the component<BR />Regards Tue, 20 Mar 2012 10:45:54 GMT Anonymous 2012-03-20T10:45:54Z https://community.qlik.com/t5/Talend-Studio/Postgresql-bulk-import-copy/m-p/2357222#M122571 Hi !<BR />We are trying to import data from a file with the postgresql bulk component.<BR />It fails because the copy command need superuser privilege (on postgresql). Does someone know how this command has been implemented ? There is indeed the copy command as OS command and the copy statement as psql statement. I think that the plugin uses the OS one and if it is so does anybody know why ?<BR />From postgresql side : <BR />psql<BR />#\copy ...........<BR />does not require superuser privilege but only GRANT INSERT on the table to wirte in.<BR />Is there another way to bulk import respecting basic security policies ?<BR />Thanks for you help<BR />Regard Tue, 20 Mar 2012 09:32:22 GMT https://community.qlik.com/t5/Talend-Studio/Postgresql-bulk-import-copy/m-p/2357222#M122571 Anonymous 2012-03-20T09:32:22Z https://community.qlik.com/t5/Talend-Studio/Postgresql-bulk-import-copy/m-p/2357223#M122572 You can find following screenshots :<BR />? job Talend using bulk component : <BR />o tpostgresqlOuputBulk : generate file<BR />o tpostgresqlOuputBulkExec : integrate file<BR />? properties of the component<BR />Regards Tue, 20 Mar 2012 10:45:54 GMT https://community.qlik.com/t5/Talend-Studio/Postgresql-bulk-import-copy/m-p/2357223#M122572 Anonymous 2012-03-20T10:45:54Z