Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephen Froehlich
Subject Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
Date
Msg-id DM5PR06MB289102D564BA106653A46FA9E5AE0@DM5PR06MB2891.namprd06.prod.outlook.com
Whole thread Raw
In response to Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view 
Will it be any faster if I put the INSERT INTO inside of a BEGIN INSERT INTO ... COMMIT?

-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Andreas Kretschmer
Sent: Tuesday, July 11, 2017 12:19 PM
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO



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



-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

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