PostgreSQL: How to insert huge data into table?

Question

Here I need to insert huge records to my database tables. How can I do that in PostgreSQL 9.3 version?

Example:

 /* Table creation */

 create table tabletest(slno int,name text,lname text, address text, city text);

 /* Records insertion */

 insert into tabletest values -- Here i need to insert thousands of records in a bulk.

Where does the data come from? Is each individual record large, or is it just many records? What exactly is the problem in your current approach of inserting the data? — deceze
– deceze ♦, Commented Jun 5, 2014 at 10:04
@deceze, and also have sql server tables records to insert into postgreSQL table. There are many records to insert. — Sarfaraz Makandar
– Sarfaraz Makandar, Commented Jun 5, 2014 at 10:11
1) Excel sheets cannot be huge for PostgreSQL :) 2) Export data to CSV (or txt) 3) Use psql \copy command. Something like: \copy tabletest from mydata.csv with delimiter ';' (read docs for details) — Tomas Greif
– Tomas Greif, Commented Jun 5, 2014 at 10:24

András Aszódi · Accepted Answer · 2014-06-05 10:27:32Z

2

Short answer: use the COPY command.

Details available in the Postgres 9.3 documentation

Note that the file should be available to the Postgres server machine because COPY is meant to be used mainly by DBAs.

And, if you have Excel, you'd have to export the data to CSV format first as Postgres cannot read Excel-formatted data directly.

answered Jun 5, 2014 at 10:27

András Aszódi

9,8005 gold badges53 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: How to insert huge data into table?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related