Re: about the copy command - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: about the copy command
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17CF498D@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to about the copy command  (Yue Wang <dawning126@gmail.com>)
List 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: getting a error message when creating temporary table
Next
From: Albe Laurenz
Date:
Subject: Re: How to avoid generation huge pg_xlog files during VACUUM , REINDEX maintenance task.