"Van Ingen, Lane" <lvaningen(at)ESNCC(dot)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