Import CSV file into PostgreSQL with PgAdmin

preview_player
Показать описание
How to create a table and import a CSV file into PostgreSQL with PgAdmin
Рекомендации по теме
Комментарии
Автор

How would this work with a DB that has many columns of many types? Surely there is a way to create a table without manually entering all columns and types(?).

joshmusic
Автор

You're the only person that's been able to help me on this. Thank you!

relax
Автор

Great video, straight to the point and really usefull! Thanks!

nelsonmorales
Автор

I LOVE YOUUUU THIS IS WHAT I'VE BEEN LOOKING

lezp
Автор

Thank you for posting this video, it helps me alot

ali_dev
Автор

Thanks a lot!

What if I have n-columns such that n can be 100 or 1000 or 10, 000 or higher, would I have to enter the column names and data types for all columns even if I have over 1, 000 columns? Or is there a technique for this?

Thanks!

sunnyolamide
Автор

This is a great video and very easy to follow. I received an error message that stopped the upload though. For some reason, it didn't like the integer data type I set for 4 of my columns. I used integer because that was the data type in the csv file for those 4 columns. Any suggestions as to how to handle this? Thanks.

theresaparker
Автор

any suggestion on INTERNAL_SERVER ERROR: 'columns'?
I mean, I got that it's hinting on the columns, I double-checked the titles and the datatypes. Don't know what else could be undertaken?

plavali_znaem
Автор

Thank you soooo much!!!! This helped a ton! :)

gbemi
Автор

It was super helpfull thankyou for the video🎉

harshitha
Автор

Thank you so much!
Do you have any idea, how can I import CSV file into PostgreSQL without create Table? (my CSV file has many many columns)

behmandtirgar
Автор

What if we don't have access to open the csv file and know its column names for making the tables, is there any alternative for it ???

sougatamitra
Автор

hello, can you explain to me how to import excel file which contains many sheets? In that case how you can specify column name if it contains so many columns?

rafailmahammadli
Автор

Thankyou so much for this, it helped me

ammarjamsheddataalchemist
Автор

Your video was very simple and understandable. I have a question. Does this process of importing files get more difficult with much bigger datasets?

Fadein
Автор

can you please post a link to your csv file here

mohikanagpal
Автор

when I import table it show me this message "Utility file not found. Please correct the Binary Path in the Preferences dialog" how to fix that?

sunnypatel
Автор

hey, so i've done everything exactly like on this tutorial, but when I run query SELEC * the columns are empty and ther is no data in them, what can be the issue?

berti
Автор

Hey beautiful. Thank you for your excellent explanation and your time. I have a question becaise I got an error by importing txt file. What if I have a colum with decimals, integers and nulls. Do you know what datatype can I use for this column with different type of data? thank u.

la_cientifica
Автор

what if the files has 1000s of columns ? huh ?

AlexMar-r