<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.38 2002/08/3003:18:23 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.39 2002/08/3016:00:41 momjian Exp $

PostgreSQL documentation

-->

There is no <command>COPY</command> statement in SQL92.

</para>

<para>

The following syntax was used by pre-7.3servers and is still supported:

The following syntax was used by pre-7.3applications and is still supported:

<synopsis>

COPY [ BINARY ] <replaceable class="parameter">table</replaceable> [ WITH OIDS ]

FROM { '<replaceable class="parameter">filename</replaceable>' | <filename>stdin</filename> }

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.59 2002/08/3003:18:23 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v 1.60 2002/08/3016:00:41 momjian Exp $

PostgreSQL documentation

-->

FOR UPDATE cannot be used in contexts where returned rows can't be clearly

identified with individual table rows; for example it can't be used with

aggregation. FOR UPDATE may also appear before LIMIT for portability with

pre-7.3servers.

pre-7.3applications.

</para>

</refsect2>

if (pq_eof()==EOF||pq_getint(&len,4)==EOF)

returnSTATUS_EOF;/* client didn't want to send password */

if (len<1||len>8192)

{

elog(LOG,"Invalid password packet length: %d; "

"must satisfy 1 <= length <= 8192",len);

returnSTATUS_EOF;

}

initStringInfo(&buf);

if (pq_getstr(&buf)==EOF)/* receive password */

{