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

Re: SQL COPY Command

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL COPY Command
Date: 2005-04-27 14:56:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
"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

In response to


pgsql-novice by date

Next:From: Keith WorthingtonDate: 2005-04-27 15:11:45
Subject: Re: SQL COPY Command
Previous:From: Van Ingen, LaneDate: 2005-04-27 14:43:58
Subject: SQL COPY Command

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