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

Watch a postgreSQL tutorial for beginners designed by Railsware Academy. Setup postgreSQL & pgAdmin from scratch, create servers, databases, schemas, and tables. Learn how to import data from .csv to postgreSQL in just a few clicks!

What you will need to download:

Timestamps:
00:42 - Download and setup postgreSQL (Mac example)
01:37 - Download and setup pgAdmin
02:26 - pgAdmin structure
02:59 - Localhost server in postgreSQL
03:58 - Create a database in postgreSQL
04:21 - What is a schema? Public schema in postgreSQL
05:23 - How to create a table in postgreSQL
06:10 - How to create fields, select data types, and set SQL constraints in postgreSQL
08:42 - Import data from csv to postgreSQL

✅ Subscribe to Railsware and learn the most efficient data analytics tools with us!

[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

[harieltenorio]

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

[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!

[ind-ram]

when i seen your channel my mind pops "ooooits railsware not Ransomware".

by the way the video presentation is cool to watch.

[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[]")?

[Paz]

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

[keifer]

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

[Leader]

Thank you. Very useful and clean explanation :)

[God-sBaby]

This was really helpful. Thank you very much

[eldenunciante]

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

[mohamed.montaser]

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

[navjotsingh]

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

[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?

[vitache]

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

[yamunadevi]

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

[tripodakisnikos]

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!

[wiolettakowalewska]

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"

[ronaldinhoroni]

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

[bhuralal]

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.