Re: update from a csv file?
От | Christian Hammers |
---|---|
Тема | Re: update from a csv file? |
Дата | |
Msg-id | 20121228131742.35bbb279@notiac.localdomain обсуждение исходный текст |
Ответ на | Re: update from a csv file? (François Beausoleil <francois@teksol.info>) |
Список | pgsql-general |
Am Fri, 28 Dec 2012 00:47:35 -0500 schrieb François Beausoleil <francois@teksol.info>: > > Le 2012-12-27 à 09:54, Kirk Wythers a écrit : > > > I have been using COPY FROM to do a mass import of records from CSV > > files into a new database. I have discover however, a small number > > of records ( a few thousand) in one of the files that contain new > > data that needs to be added to the database, but on rows that have > > a primary key and have already been inserted (so I can't use COPY > > FROM because it violates the primary key). ... > You will want to COPY FROM on a new table that has the same structure: > > BEGIN; > CREATE TEMPORARY TABLE original_table_name_temp( LIKE original_table_name INCLUDING ALL ); > COPY original_table_name_temp FROM stdin; The "INCLUDING ALL" will also generate the same unique keys that let the COPY fail in the original table so omit that. bye, -christian-
В списке pgsql-general по дате отправления: