Re: SQL COPY Command - Mailing list pgsql-novice

From Keith Worthington
Subject Re: SQL COPY Command
Date
Msg-id 20050427151319.M46733@narrowpathinc.com
Whole thread Raw
In response to Re: SQL COPY Command  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL COPY Command
Next
From: "Keith Worthington"
Date:
Subject: Re: SQL COPY Command