PostgreSQL tutorial for beginners 2024: setup postgreSQL and pgAdmin | postgreSQL .csv import

[@TuckerPastor]

Just wanted to underscore the last comment. I spent all Sunday screwing up on importing a CSV file to create a table. I didnt know that postgresql had a form. This made it so much easier

[@alincehs]

Thank you for the tutorial! Would you kindly let me know what is the difference between data type with parenthesis and the one without parenthesis? (e.g. "char" and "char[]")?

[@harieltenorio9700]

Thank you so much!! I am a total beginner and I was very lost until I saw your video

[@coupleracademy]

You're so welcome!

[@AfricanFlightStar]

Wow, this is THE BEST beginner instructional video I've found on postgreSQL. It's clear, concise and does not skip anything important. Very, very good teaching style, thank you. I'll be watching a lot more of these RailAcademy videos and hopefully finally learn how to use postgreSQL. Cheers!

[@coupleracademy]

Thank you so much for such a wonderful feedback. Happy that you found the tutorial helpful!

[@ind-ram]

when i seen your channel my mind pops "ooooits railsware not Ransomware". by the way the video presentation is cool to watch.

[@vitache1276]

how can I copy a column with a particular id from one postgresql database server to another with the sa me structure

[@Relanii]

How do I create a table if my data set has thousands of rows? I cannot possibly write out each name manually it would be impossible.

[@SukeshSrinivas]

How to import large number of columns without copying each column name to create table?

[@coupleracademy]

You can try using CSV to SQL converters. Just copy and paste the first couple of rows in the editor and then copy generated schema. www.convertcsv.com/csv-to-sql.htm

[@yamunadevi9106]

After executing the select query only the field name is displaying and the data is not displayed.........pls help me to solve this!!

[@navjotsingh2251]

If we make changes to the csv file will those changes be reflected on postgresql?

[@Leader977]

Thank you. Very useful and clean explanation :)

[@ruhi4307]

Thank you so much for this tutorial

[@ronaldinhoroni1254]

HI ! the method is the same for csv file with missing values ?

[@tripodakisnikos2825]

Thank You for this tutorial!!!... When I went to import the csv file... this "Please configure the PostgreSQL Binary Path in the Preferences dialog." displayed.... I don't know what to do....Please help!

[@TapiwaWakatamaVHP]

@Tripodakis Nikos this video had the solution > kzbin.info/www/bejne/b5uvm4h_oNVqbrs

[@minvent663]

Resolution 1. Open PGAdmin 2. Expand File and select Preferences. 3. Scroll down to Path>Binary Paths and click on it. 4. Scroll down to PostgreSQL Binary Path 5. Choose the option to select path beside the current version of PostgreSQL installed. 6. The usual path would be C:\Program Files\PostgreSQL\bin. This might be vary if the installation has been done on a different folder. 7. Hit Save. 6. Selecting restore option should be give you an utility to choose the backup location.

[@Muhammad_Jaamiu]

When I click import/export It keeps telling me to configure the PostgreSQL Binary path in the preferences dialog. I don't know what to do

[@cerenalkan4567]

Try File>Preferences>BinaryPath and write your path to PostgreSQL Binary Path session.

[@Muhammad_Jaamiu]

@@cerenalkan4567 am I writing this as a query?

[@cerenalkan4567]

@@Muhammad_Jaamiu No just click on pgAdmin menu.

[@yahampathmarambe8879]

my excel table has 20 columns, should i manually create table similar to that on pgadmin?

[@willy7968]

Have you found a workaround for this? In MySQL, u can easily use the import wizard for csv files with much columns

[@wiolettakowalewska9808]

I can't upload file csv: ERROR: date/time field value out of range: "10/13/2018" HINT: Perhaps you need a different "datestyle" setting. CONTEXT: COPY Applicants, line 29, column application_date: "10/13/2018"

[@coupleracademy]

Try to apply YYYY-MM-DD format to dates before uploading data, another solution would be uploading as is to a string column and then apply TO_DATE(string_column, 'MM/DD/YYYY')

[@God-sBaby]

This was really helpful. Thank you very much

[@keifer7813]

Thank you so much, amazing video. Might just go through the others now

[@bhuralal5299]

I have 284 columns on my table and if try to do this one by one, From the next day I won't be able to enter my office.

[@mohamed.montaser]

yes the video i was waiting for .. thanks for notifying me

[@coupleracademy]

Hope you enjoyed it!

[@davidreichert9392]

When I click on Import/Export, I get this message: "Utility file not found. Please correct the Binary Path in the Preferences dialog" Anybody else seen this or know what to do about it?

[@minvent663]

Resolution 1. Open PGAdmin 2. Expand File and select Preferences. 3. Scroll down to Path>Binary Paths and click on it. 4. Scroll down to PostgreSQL Binary Path 5. Choose the option to select path beside the current version of PostgreSQL installed. 6. The usual path would be C:\Program Files\PostgreSQL\bin. This might be vary if the installation has been done on a different folder. 7. Hit Save. 6. Selecting restore option should be give you an utility to choose the backup location.

[@Paz1]

I had table name with capital letter and import wasn't working. Per video, I lower cased the table name and it worked. Thanks. :D

[@marcgonz12]

Very clear tutorial Thank you.

[@jennykkk]

thank you thank you

[@coupleracademy]

You are welcome!

[@nazimulhchoudhury6513]

Thank you for the tutorial

[@pratapkhadap1085]

Thank you so much 😇

[@eldenunciante45]

Can't download the sheet because of access, anyways this is the tutorial I was needing a while ago. Subscribed and terrific job!

[@coupleracademy]

Alonso, please, check now: bit.ly/3fLbJxX

[@eldenunciante45]

@@coupleracademy Already in! Thanks so much. Keep up the good job!

[@giorgosi.fovakis8810]

Thank you so much!

[@daniltosilva8241]

Thank you, very good

[@weppacloud339]

Thank you

[@martinavarro98]

thank you queen

[@funtime12345]

Good One

[@rickbarnesmusic]

Great video! Take a look at my channel and stay tuned if you like my content 😊😊

[@rivari22]

nice video

[@pedaballinani307]

Sollu

[@AnshulMarele-gbaa]

How to import CSV without creating table in the postgre?