Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO

Поиск
Список
Период
Сортировка
Искать
От
Andreas Kretschmer
Тема
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Дата
Msg-id
d0417519-5358-6177-9ef5-893a288d0fa1@a-kretschmer.de
Ответ на
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO (Stephen Froehlich)
Список
Дерево обсуждения
[NOVICE] COPY from temp table to main table insted of INSERT INTO Stephen Froehlich <s.froehlich@cablelabs.com>
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO "David G. Johnston" <david.g.johnston@gmail.com>
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO Stephen Froehlich <s.froehlich@cablelabs.com>
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO "David G. Johnston" <david.g.johnston@gmail.com>
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO Andreas Kretschmer <andreas@a-kretschmer.de>
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO Stephen Froehlich <s.froehlich@cablelabs.com>
Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO "David G. Johnston" <david.g.johnston@gmail.com> 


Am 11.07.2017 um 19:04 schrieb Stephen Froehlich:
> I have already copied the source data over from R in an unnormalized 
> form and then am normalizing it in SQL (via a series of queries).

in this case you can use insert into ... select ... from ...

Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
В списке pgsql-novice по дате отправления
Предыдущее
От: David G. Johnston
Дата:
Следующее
От: Stephen Froehlich
Дата:
FAQ