PostgreSQL - PgAdmin 4 - Import csv file using PgAdmin

(
objectid bigserial,
DistrictName text,
inside_x double precision,
inside_y double precision
);

-----------------------------------------------------------------------------------

OBJECTID,DistrictName,INSIDE_X,INSIDE_Y
1,Adilabad,78.56,19.52
2,Bhadradri Kothagudem,80.7,17.68
3,Hyderabad,78.46,17.39
4,Jagtial,78.87,18.83
5,Jangoan,79.27,17.73
6,Jayashankar Bhupalpally,80.16,18.37
7,Jogulamba Gadwal,77.78,16.07
8,Kamareddy,78.06,18.32
9,Karimnagar,79.23,18.38
10,Khammam,80.35,17.19
11,Kumarambheem Asifabad,79.41,19.35
12,Mahabubabad,79.98,17.66
13,Mahabubnagar,77.8,16.7
14,Mancherial,79.51,18.99
15,Medak,78.25,17.95
16,Medchal_Malkajgiri,78.55,17.54
17,Nagarkurnool,78.58,16.38
18,Nalgonda,79.19,16.87
19,Nirmal,78.31,19.11
20,Nizamabad,78.2,18.7
21,Peddapalli,79.45,18.62
22,Rajanna Sircilla,78.76,18.42
23,Rangareddy,78.41,17.13
24,Sangareddy,77.87,17.78
25,Siddipet,78.84,18
26,Suryapet,79.75,17.08
27,Vikarabad,77.74,17.25
28,Wanaparthy,78.03,16.29
29,Warangal_Rural,79.75,17.92
30,Warangal_Urban,79.47,18.02
31,Yadadri Bhuvanagiri,78.98,17.45

[Pipex]

Thanks very much! today I learned something new thanks to you.

[pratikrane]

Thank you! I liked how you covered all steps in just 2 min video, everything right on point, and no long bullshit explanations. Keep up the good work, mate.

[akpotomafavour]

Thank you so much for this video, I was able to import my data.

[junelee]

It's really helpful!! Really appreciate it!👏👏

[harshakusunuri]

Worked for me, followed same steps. Great work!

[BUSINESS_NUMBERS]

Hi I tried with your method but after the import (succesfully completed) the table is empty.. Can someone help me? thank you

[ItsWithinYou]

Thank YOU! You saved my time! As an alternative, if number of columns are small, then we can also go to table then right click and select create table and then click columns option and enter column names one by one from there.

[ZxLuizNeroxZ]

THANK YOU SO MUCH, YOU HELPED ME A LOT.

[mattezoc]

Dimag kharab hogaya tha kyu import nhi ho raha, finally hogaya, thanks 🙏
Maine header option on nhi kiya tha isliye nhi ho raha tha thanks

[pradeepag]

Hello! I do the same thing the first message comes up "Import / Export job created" but 2nd message doesn't come up nor the data gets loaded. Can u let me what is that I'm missing?

[vidyakamath]

Okay, can you please tell how do we import JSON data from CSV?

[crownandguillotine]

If you get a UTF8 error try setting the encoding to windows-1251.

[pooja]

Thank you @bhaskar, Is the copy command not working now?

[sirapanasettykarthik]

after clicking on import data i am getting (utility file not found, please correct the binary path in the preferances dialog) like this

[SukeshSrinivas]

Hi, Thanks for the video.
If the number of columns are really huge, how to import csv file into postgres at ease?

[plavali_znaem]

Following along, and getting 'INTERNAL SERVER ERROR: columns' error. Anybody to resque?

[nassiri]

While creating a new table, I get the sign of the lock next to each column name I create, and due to that I can't import any data in there. Please help!

[khadhraouijasser]

I always get this error:
ERREUR: syntaxe en entrée invalide pour le type integer : « »
CONTEXTE : COPY profil, ligne 1, colonne profil_id : « »

[aaronhaefner]

Thank you for the helpful video. Do you know how to import CSV files with more than 1 million rows? I have a file with about 1.5m rows, but only the first million get imported. Thanks!

[valbotero]

when trying to import i get an error that says read-only file system. im on mac, any help?