Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Date
Msg-id d0417519-5358-6177-9ef5-893a288d0fa1@a-kretschmer.de
Whole thread Raw
In response to Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Responses Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO  (Stephen Froehlich <s.froehlich@cablelabs.com>)
List pgsql-novice
Tree view 

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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Next
From: Stephen Froehlich
Date:
Subject: Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO