[postgresql] 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

You may have a table called 'test'

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

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