Re: SQL COPY Command - Mailing list pgsql-novice

"Van Ingen, Lane" <lvaningen@ESNCC.com> writes:
> Will this command APPEND TO or REPLACE data in an existing table ?
> The documentation doesn't seem to indicate.

The first paragraph on the COPY reference page is

COPY moves data between PostgreSQL tables and standard file-system
files. COPY TO copies the contents of a table to a file, while COPY FROM
copies data from a file to a table (appending the data to whatever is in
the table already).


            regards, tom lane