Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 636
abhim Avatar asked Oct 16 '13 09:10

abhim


People also ask

How do I import a CSV file into PostgreSQL database using pgAdmin?

To import CSV using this PgAdmin Import CSV method, you have to do the following: Click on the Tools tab at the top of your PgAdmin Home Page. Select the Query Tool in the drop-down menu that appears. Enter the title and columns in your CSV file as an SQL Query.

How do you load data into a table in pgAdmin?

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.


1 Answers

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

like image 132
Tomas Greif Avatar answered Oct 08 '22 15:10

Tomas Greif