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!
Use a practice sheet designed by Railsware Academy: https://bit.ly/3eEli0w
What you will need to download:
postgreSQL for Mac: https://postgresapp.com/
postgreSQL for Windows: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
pgAdmin: https://www.pgadmin.org/download/
Learn more about localhost: https://bit.ly/3fLbJxX
Discover how schemas work: https://www.postgresql.org/docs/current/ddl-schemas.html
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
đ Contact Railsware to build your software product http://bit.ly/contactrailsware
đ¤ Join Railsware team http://bit.ly/railswarecareers
â
Subscribe to Railsware and learn the most efficient data analytics tools with us!
đ§ Try Coupler.io – a tool for safe data imports from various tools to GSheets: https://bit.ly/3fMhSdk
đ Download Coupler.io in GSuite marketplace: https://bit.ly/2OFM4Lp
source
29 replies on “PostgreSQL tutorial for beginners 2021: setup postgreSQL and pgAdmin | postgreSQL .csv import”
Thank you so much đ
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
Thank you for the help. You really saved me a lot of time with this!
Sollu
Thank you for the tutorial
how can I copy a column with a particular id from one postgresql database server to another with the sa
me structure
Great video! Thank you!
If we make changes to the csv file will those changes be reflected on postgresql?
Thank you, very good
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.
Thank you so much!
I had table name with capital letter and import wasn't working. Per video, I lower cased the table name and it worked. Thanks. đ
when i seen your channel my mind pops "ooooits railsware not Ransomware".
by the way the video presentation is cool to watch.
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[]")?
Good One
Thank you
HI ! the method is the same for csv file with missing values ?
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!
Very clear tutorial Thank you.
Thank you so much!! I am a total beginner and I was very lost until I saw your video
After executing the select query only the field name is displaying and the data is not displayed………pls help me to solve this!!
thank you queen
Perfect tutorial, many thanks!
How to import large number of columns without copying each column name to create table?
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"
nice video
Can't download the sheet because of access, anyways this is the tutorial I was needing a while ago. Subscribed and terrific job!
Great video! Take a look at my channel and stay tuned if you like my content đđ
yes the video i was waiting for .. thanks for notifying me