Skip site navigation (1) Skip section navigation (2)

Re: SQL COPY Command

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL COPY Command
Date: 2005-04-27 15:14:59
Message-ID: 20050427151319.M46733@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 27 Apr 2005 10:56:09 -0400, Tom Lane wrote
> "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

Sheesh, how did I miss that?

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

Kind Regards,
Keith

In response to

pgsql-novice by date

Next:From: Bruce MomjianDate: 2005-04-27 15:59:12
Subject: Re: Poor-man's enumeration type
Previous:From: Keith WorthingtonDate: 2005-04-27 15:11:45
Subject: Re: SQL COPY Command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group