i watched and read several articles on how to add a .csv file but wasn't able to add it finally i figured it out from your video that i should have checked the header .. thanks mate
@RealAndyOriginal
Жыл бұрын
What if you are trying to import a csv file that has 300 columns? You have to manually type in all the column names and column types? There has to be an easier way.
@jayeshsuryawanshi2155
Жыл бұрын
exactly
@JeffreyJohnsonC
11 ай бұрын
You could do it programmatically with a script to create the fields.
@graceamah996
5 ай бұрын
@@JeffreyJohnsonChow please
@Cahangir
Ай бұрын
That is a gigantic problem of PostgreSQL and shamelessly, they've attempted to compare this garbage to MSSQL.
@gospelmoto2833
Ай бұрын
Good question! your question is as good as mine.
@gospelmoto2833
Ай бұрын
Is there a way to import the csv files without defining first the table structures? Upon importing, it will automatically detect and create the headers.
@SilviaGarcia-bv7cz
3 ай бұрын
Thank you very very much! from Argentina
@soumyajeetmitra6958
7 ай бұрын
wow great fun and brief learning
@kadakolo5642
Жыл бұрын
Is it really necessary to create each table manually? I have a mysql database with 120 tables, tens of thousands rows of data - some tables have like 20-100 columns - this will take a week to just create them ?
@wolverinelogan8980
Жыл бұрын
May I ask a question. What if I am going to import a csv file that has 300 or 500 columns given by the company I am working with. Do I necessarily do that? It would take some time for them to get the insights they wanted. What if there are 10 tables with 400 columns each. Do I really need to do that to provide the insights that the company is expecting?
@gospelmoto2833
Ай бұрын
Good question! your question is as good as mine.
@e.b.9178
Ай бұрын
Thank you so much!
@jesuslogistico7067
Жыл бұрын
I'm from Brazil, thanks for the help
@mikeossola6397
Ай бұрын
Thank you!
@silvestrecamposano6317
Жыл бұрын
Sir, ... Thank you very much for the technique... I can apply it in my office job....
@omgurav1128
Ай бұрын
thank you so much sir , i trying import data by using copy it give me error , after watching your tutorial it really help me
@TimRubel
2 ай бұрын
I'm using this in docker and I can't access my local files. Do you have any resources?
@kumaraswamy3452
7 ай бұрын
thanks mate , helped me a lot
@daveys
6 ай бұрын
Good tutorial, thanks for that
@JeffreyJohnsonC
11 ай бұрын
Good tutorial.
@rishabhchakraborty1819
Жыл бұрын
Thanks
@OluchiMae
7 ай бұрын
Hi I tried but it keeps failing every time Process started is successful but the other one isn’t
@abdullahoguntade1649
7 ай бұрын
I also had similar problems but if you check the error you should see what went wrong. In my own case i made a mistake in the datatype check your csv file properly to ensure that each column has the same dtattype in all rows and it doesnt have an error in the csv file
Пікірлер: 27