current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Join the Stack Overflow Community
Stack Overflow is a community of 6.5 million programmers, just like you, helping each other.
Join them; it only takes a minute:
Sign up
up vote 31 down vote favorite
6

Is there any plugin or library which I need to use for this? I want to try this on my local system first and then do the same on Heroku Postgresql

share|improve this question
up vote 50 down vote accepted

pgAdmin has GUI for data import since 1.16. You have to create your table first and then you can import data easily - just right-click on the table name and click on Import.

enter image description here

enter image description here

share|improve this answer
1  
How should I map columns from CSV to the table columns? – abhim Oct 16 '13 at 11:21
2  
This expects that columns in your table match 1:1 to your CSV file, including order of columns. There is no need for mapping. – Tomas Greif Oct 16 '13 at 11:36
    
I am having issues with unique constraint, how can I omit the duplicate data? – abhim Oct 16 '13 at 11:46
    
There is no way you can handle this during import. Remove constraint from table, import data, delete duplicate data and then add your constraint back. – Tomas Greif Oct 16 '13 at 12:03
    
RE: mapping columns in CSV to table… pgAdmin expects the CSV to match the natural order of the columns (order in which columns were added to table). This is just a limitation of pgAdmin. Underneath, pgAdmin is actually just using the COPY command. If you were to write the SQL for COPY yourself you could specify a different ordering of columns being imported. Also, notice the "Columns" tab where you can tell pgAdmin that some columns are omitted in the CSV so a default value should be generated. – Basil Bourque Apr 2 at 4:40
up vote 16 down vote

assuming you have a SQL table called mydata - you can load data from a csv file as follows:

COPY MYDATA FROM '<PATH>/MYDATA.CSV' CSV HEADER;

For more details refer to: http://www.postgresql.org/docs/9.2/static/sql-copy.html

share|improve this answer
up vote 2 down vote

You may have a table called 'test'

COPY test(gid, "name", the_geom)
FROM '/home/data/sample.csv'
WITH DELIMITER ','
CSV HEADER
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.