Re: Importing/Appending to Existing Table
От | Sergey Konoplev |
---|---|
Тема | Re: Importing/Appending to Existing Table |
Дата | |
Msg-id | AANLkTi=3iGdaGZC6V2GX7t+iNAMkTLgmhWEOsnqA_pqZ@mail.gmail.com обсуждение исходный текст |
Ответ на | Importing/Appending to Existing Table (Rich Shepard <rshepard@appl-ecosys.com>) |
Ответы |
Re: Importing/Appending to Existing Table
|
Список | pgsql-general |
On 2 February 2011 03:28, Rich Shepard <rshepard@appl-ecosys.com> wrote: > 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? No it wont overwrite, it will append rows. > > Rich > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp
В списке pgsql-general по дате отправления: