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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: COPY from temp table to main table insted of INSERT INTO
Date: 2017-07-11 18:19:25
Message-ID: d0417519-5358-6177-9ef5-893a288d0fa1@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Froehlich 2017-07-11 18:40:35 Re: COPY from temp table to main table insted of INSERT INTO
Previous Message David G. Johnston 2017-07-11 17:42:45 Re: COPY from temp table to main table insted of INSERT INTO