ql-general@postgresql.org
Subject: Re: [GENERAL] Importing/Appending to Existing Table
On Wed, 2 Feb 2011, Greg Williamson wrote:
> It will not overwrite any existing data; if the table has constraints
> that will prevent duplicates then the entire load will fail if any
> item fails (i
On Wed, 2 Feb 2011, Greg Williamson wrote:
It will not overwrite any existing data; if the table has constraints that
will prevent duplicates then the entire load will fail if any item fails
(it is a single transaction).
If the table doesn't have such constraints then duplicate data in the copy
On Wed, 2 Feb 2011, Sergey Konoplev wrote:
No it wont overwrite, it will append rows.
Thank you, Sergey.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Rich --
>
>
> I have an existing table with 15,492 rows and want to add additional rows
> from a .csv file. If I use 'COPY from with delimiter
> as ":" csv quote as "'" ' will this overwrite existing rows in the table or
> append rows?
It will not overwrite any existing data; if the table h
On 2 February 2011 03:28, Rich Shepard wrote:
> I have an existing table with 15,492 rows and want to add additional rows
> from a .csv file. If I use 'COPY from with delimiter
> as ":" csv quote as "'" ' will this overwrite existing rows in the table or
> append rows?
No it wont overwrite, it
