Thread: COPY command
Is the copy command using SQL or does it do its magic using some lower level mechanism? In short, my question is whether I can somehow use something like copy from a Perl script? -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions
Mladen Gogala <mgogala@vmsinfo.com> writes:
> Is the copy command using SQL or does it do its magic using some lower
> level mechanism? In short, my question is whether I can somehow use
> something like copy from a Perl script?
COPY to/from the client (as opposed to to/from a file) involves some
special protocol. If your Perl driver knows how to do COPY, the
answer is yes.
regards, tom lane
On Thursday, August 26, 2010, Tom Lane <tgl@sss.pgh.pa.us> wrote: > COPY to/from the client (as opposed to to/from a file) involves some > special protocol. If your Perl driver knows how to do COPY, the > answer is yes. > > regards, tom lane DBD::Pg has been able to do it for quite a while.
Alan Hodgson wrote: > On Thursday, August 26, 2010, Tom Lane <tgl@sss.pgh.pa.us> wrote: > >> COPY to/from the client (as opposed to to/from a file) involves some >> special protocol. If your Perl driver knows how to do COPY, the >> answer is yes. >> >> regards, tom lane >> > > DBD::Pg has been able to do it for quite a while. > > I should remember to read the manuals. Thank you very, very much! -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions