View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 09:45 PM
Tom Lane
 
Posts: n/a
Default Re: SQL COPY Command

"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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Reply With Quote