On Wed, 27 Apr 2005 10:56:09 -0400, Tom Lane wrote
> "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

Sheesh, how did I miss that?

Oh well, Documentation talks the talk but testing walks the walk. ;-)

Kind Regards,
Keith

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq