Re: about the copy command

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Yue Wang *EXTERN*" <dawning126(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: about the copy command
Date: 2014-04-29 08:09:02
Message-ID: A737B7A37273E048B164557ADEF4A58B17CF498D@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yue Wang wrote:
> I read this http://www.postgresql.org/docs/8.4/static/libpq-copy.html
> I want to send the copy command and then send the data directly. the server don't send the
> PGRES_COPY_IN to the client.
>
> While receive the copy in command, the server already know how to do. so the server begin to receive
> data directly.
>
> While receive the copy to command, the server already know how to do. so the server begin to send data
> directly. And the client receive data directly.
>
> So I want to delete the send of PGRES_COPY_IN or PGRES_COPY_OUT.

Why? What do you want to achieve?

You have to wait for the server's reply that tells you that the server is
ready to receive the data.

What if there is an syntax error in your COPY command?

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2014-04-29 08:20:33 Re: How to avoid generation huge pg_xlog files during VACUUM , REINDEX maintenance task.
Previous Message Tom Lane 2014-04-29 02:45:13 Re: getting a error message when creating temporary table