Import Excel/CSV file data into Postgresql database table pgAdmin 4

Best Technologies Learn here. This is the best platform to learn new and emerging technologies
Import Excel/CSV file data into Postgresql database table

[@VSrants]

I watched multiple videos but this video was life saver. Thank you

[@ganeshsharma-yk7yw]

this video is very helpful, it helps me alot i was stuck in uploading the files in SQL, and after watching this just understands and done the uploading. thank you sooo much.

[@rohityetre1867]

Thank You Very Much Ma'am 🙌✨

[@BestTechLearn]

Most welcome 😊

[@jajha6240]

Thanks a lot it works

[@e.b.9178]

Thank you for your clear and short explanation! But SQL platforms are so annoying compared to python and R! Why it takes so much work for a simple upload of a data file while in R you can do it in less than 10 seconds?

[@承瑋施-m3j]

Hello, thank you for the tutorial. But I wonder is it possible to do the same thing (import the excel file to psql) in terminal (by command line) ?

[@abhishekshishodia7767]

if you know please connect to me i want to know this method as well.

[@rudranshchaudhary20]

thank u so much and subscribed

[@BestTechLearn]

Thankyou

[@edid6395]

You are the best!!!

[@sumitchaudhari5815]

what or how we do when we have more than 30 columns do we need to type all the column names while creating table before importing excel file?

[@sushugowda5743]

yes

[@rafailmahammadli8665]

if the data contains so many columnss, we shoul write them manually? There isnt any way for importing excel file easily?

[@khadijabibi8894]

Hello....I want to ask something....can you tell me if you found any easy method to load csv file into postgresql

[@DevinGreenhalgh]

I tried to do that, but keep getting an error because csv converts everything to string when column is define as integer.

[@mjshoaib9316]

@besttechlearn I have question maam , if i replace the csv file with same name file and structure everyday will it update in database??

[@alonewolf7682]

thank you very much

[@BestTechLearn]

Glad it helped

[@aniketwanjari2624]

Mam is it mandatory to upload in csv format?

[@pranithachappidi4324]

Can someone help me with this error, it says permission denied and SQL state 42501- for Mac

[@SirajuddinMohammed-zh8im]

My data import is showing as failed even though the Data type what I am entering is correct...How to find the reasons?

[@buntyswain]

all the field names that are present in the database should be present in excell sheet?

[@amankumar5021]

Yes it's mandatory

[@valdirsilva5095]

Thank you very much!!!!!!

[@gopaljigupta5158]

thank you for this video

[@Nick-ih9kl]

Thank you

[@HarinadhaVasala]

Hello sir for float values which data type I use?

[@K_Michael]

float should do

[@kripeshrajan6301]

Thanks

[@ghettoghost2657]

Anyone know why "Tables" isnt visible on the left hand side for me

[@BestTechLearn]

Try refreshing..

[@Asgar463]

Thanku so much

[@daivaizhampt7418]

Thank you for this.

[@Engineerx356]

Tqsm

[@amjadjaki]

Can any one extract those data which you uploaded or it’s only you can see it and not public?

[@rohitraghuwanshi9439]

thanku

[@DevinGreenhalgh]

Can someone help?

[@dannyben0]

ERROR: missing data for column "address" CONTEXT: COPY schools, line 2: "St. Joseph;Joseph school str 1;Orlan;1234566" I can not import my data, eventhough I have been checking many times that nothing is incorrect.

[@dannyben0]

Got it. change the ' , ' to ' ; '

[@ashmitshelke1444]

bro postgre is cursed