If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > Starting help for bulkload

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-23-10, 10:22
Depress Depress is offline
Registered User
 
Join Date: Nov 2010
Posts: 1
Starting help for bulkload

Hi,

I got myself pg_bulkload installed. I can use it from the command line, but i need to use it from inside a stored procedure.

But the problem is that i don't know how to use the function. The function is defined as below:
Code:
CREATE OR REPLACE FUNCTION pg_bulkload(IN options text[], OUT skip bigint, OUT count bigint, OUT parse_errors bigint, OUT duplicate_new bigint, OUT duplicate_old bigint, OUT system_time double precision, OUT user_time double precision, OUT duration double precision, OUT messages text)
RETURNS record AS
'$libdir/pg_bulkload', 'pg_bulkload'
LANGUAGE c VOLATILE STRICT
COST 1;
Does anyone has experience with the use of this function?

Thanks! Depress
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On