On Wed, Oct 1, 2008 at 8:04 AM, Sergey A. <n39052@gmail.com> 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.