On Wed, Oct 1, 2008 at 8:04 AM, Sergey A. <n39052@xxxxxxxxx> wrote: >> There is a network API for COPY. Look up pg_put_line (or PQputLine >> or whatever the convention is for whatever API you're using). > > Thanks for your answer. I use Erlang (erlang.org) + pgsql2 (it's > native Erlang driver maintained by ejabberd developers). All all I > have is the following functions: > > connect(User,Password,Database,Options) > stop(Pid) > q(Pid,Query) > q(Pid,Query,Params) > q(Pid,Query,Params,Options) > execute_many(Pid,Query,Params) // I use this function to do buffered inserts > execute(Pid,Query,Params) > apply_in_tx(Pid,Fun,Args) // it's for transactions > get_parameters(Pid) // some information about connection the execute many should probably work. Just load it up with the same kind of lines you'd see come out of pg_dump -t tablename That's the easiest way to see an example.
