How should I import data from CSV into a Postgres table using pgAdmin 3?
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
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.
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