Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephen Froehlich
Subject [NOVICE] COPY from temp table to main table insted of INSERT INTO
Date
Msg-id DM5PR06MB2891AE381C635F8453F80193E5AE0@DM5PR06MB2891.namprd06.prod.outlook.com
Whole thread Raw
Responses Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO
List pgsql-novice
Tree view

I tend to do mass inserts to my database, but INSERT INTO is taking quite a while for 100k values.

 

What is the syntax for using the COPY command to copy a well formatted temp table to the “end” of the primary table?  I am having trouble understanding https://www.postgresql.org/docs/9.5/static/sql-copy.html.

 

Thanks,

Stephen

 

pgsql-novice by date:

Previous
From: Ed Behn
Date:
Subject: Re: [NOVICE] where and how to store calculated data?
Next
From: "David G. Johnston"
Date:
Subject: Re: [NOVICE] COPY from temp table to main table insted of INSERT INTO