Postgres Pro
Downloads
Home   >   mailing lists

Importing/Appending to Existing Table - Mailing list pgsql-general

From Rich Shepard
Subject Importing/Appending to Existing Table
Date
Msg-id alpine.LNX.2.00.1102011624400.20317@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Importing/Appending to Existing Table  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Importing/Appending to Existing Table  (Greg Williamson <gwilliamson39@yahoo.com>)
List pgsql-general
Tree view 
   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

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Select for update with offset interferes with concurrent transactions
Next
From: Aleksey Tsalolikhin
Date:
Subject: Re: Why does my DB size differ between Production and DR? (Postgres 8.4)