In response to "Scott Marlowe" <scott.marlowe@gmail.com>:
> On Wed, Oct 1, 2008 at 7:58 AM, Sergey A. <n39052@gmail.com> wrote:
> >> Sure it does.
> >>
> >> copy .... from STDIN
> >> 213 345 567
> >> 847 837 473
> >> \.
> >
> > Thanks. Was this query entered in psql shell?
>
> Yes, but if you're using something like php, you can enter it as a
> single string and it will work.
php also has pg_put_line(), which reduces the memory overhead on both
the client and server. Hopefully, whatever language you're using has
an API for expediting as well.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023