| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-04-27 15:59:12 | Re: Poor-man's enumeration type |
| Previous Message | Keith Worthington | 2005-04-27 15:11:45 | Re: SQL COPY Command |