Importing/Appending to Existing Table

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Importing/Appending to Existing Table
Date: 2011-02-02 00:28:54
Message-ID: alpine.LNX.2.00.1102011624400.20317@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have an existing table with 15,492 rows and want to add additional rows
from a .csv file. If I use 'COPY <tablename> from <filename> with delimiter
as ":" csv quote as "'" ' will this overwrite existing rows in the table or
append rows?

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-02-02 00:36:15 Re: Select for update with offset interferes with concurrent transactions
Previous Message Devrim GÜNDÜZ 2011-02-02 00:09:39 Re: yum repo problem