Rich --
>
>
> 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?
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 file
will result in duplicate rows.
HTH,
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
