Getting Started with PostgreSQL for Windows | 2021

PostgreSQL is a modern relation database that has been in active development for more than 30 years. It's Open Source and great to use for own projects or real applications.
Free PostgreSQL Course
- amigoscode.com/courses/postgr...
In this video you will learn how to:
- Install PostgreSQL on Windows
- Use PSQL
- Use PGAdmin
- CRUD operations
PS:
Subscribe to my channel: / amigoscode
Follow on Instagram: / amigoscode
Happy coding 👊🏾

[@dylangodfrey902]

Ive scurried all over the internet and this guy is the most clear and straight to the point as can be. Great video lad and your accent was a bonus!!

[@nicholasho7956]

The permission error at 16:56 you get is because you are using the '\' slashes instead of '/' Just change them around and then the file gets imported with no problems. Thanks so much for this video - it rocks :0)

[@amigoscode]

Thanks buddy. I haven't used Windows for almost 10 years now

[@waheedafolabi6264]

Worked. Thanks for the insight, @Nicholas and great video @Amigoscode

[@atanupaul5327]

the '/' is not working \i C:/Users/Atanu Paul/Desktop/test1.sql; this is the command still shows permission dennied why???

[@extremepillows]

@@atanupaul5327 it works for me tho

[@shobhitsharan2027]

thanks, Man, I was stuck on this for long

[@fxgraphicslive]

without a doubt the best, most complete tutorial for anything I have seen on yt. Thank you very much!

[@RattyScorpion]

Thank you so much for this. My professor threw us into an assignment with no knowledge of how to set up PostgreSQL and no prior experience using SQLs. I had to learn it all from this video.

[@SosetaFurioasaJr]

Thanks Nelson. I actually came from your Spring Boot Tutorial because I installed PostgreSQL but during installation I did not specify a password because I did not know exactly it's use and did not want to get bogged down with another password. After I installed the software, I could not access the server in any way shape or form because it would not recognize any password I inputted and I could not reset it. So what I did I uninstalled PostgreSQL and reinstalled it using this tutorial. Now it works and I can continue your Spring Boot tutorial. Thanks!

[@Name-qt6jv]

I was looking for a new and relevant tutorial and finally have found it! Thank you so much!

[@amigoscode]

You welcome again

[@changofaceanimations5402]

Thank you Amigo, you have fantasticly succinct and easy to understand tutorials! I liked and subscribed (with notifications).

[@antonyrichard369]

I am new to PGres and this beginner tutorial of yours is very helpful !! Thanks a bunch 🙏

[@Renee11123]

I just started learning postgres and I'm overjoyed about this. I was intimidated by using the shell and couldn't import files for the first time and nearly given up. Your video helped me enjoy learning how to use postgres even more. Keep it up!

[@andreas-fefe]

Definitely Nelson you are the best, Thanks for all. Keep up

[@timjohnston6072]

Awesome video. Straightforward, easy to follow, and complete. Really appreciate it.

[@amigoscode]

Glad you liked it

[@dimplesantoshi8561]

Wow! such an amazing way of explaining...everything was so clear...step by step..thank you so much!

[@amedeekreuzer9190]

Thank you very much dear Nelson, everything worked with the terminal and also with pgAdmin4. Many many thanks!

[@ganeshk2156]

You have no idea how useful this video was you hurt me alot man thank you so much. Hats off to ur explanation. ❤️ From India

[@asterixcode]

16:37 when you get Permission denied, to make it works you just need to pass the entire path wrapped by a single quotation + double backslash \\ So the command would be: \i 'C:\\Users\\lucas\\Desktop\\sql.sql' (of course change the username \\lucas here to your own username or path)

[@cabdicaziizqaasimmaxamed7225]

Thank you sir it worked;)

[@vude123]

many thanks sir

[@uchejames409]

Thank you so much. It worked for me.

[@rudra2036]

thank u thank u

[@mussiekebede2575]

Nelson, you are the best. Keep the good work. This video helped me understand command line syntax.

[@billyinthelowland]

Direct, concise and to the point. Thanks for a great introduction. Subscribed and will check out your other courses.

[@amigoscode]

Glad it was helpful!

[@jeevantha123]

Great content and easy to follow. Fantastic video mate!

[@victoria19162]

Thank you so much! Brilliant explanation of the topic - it helped massively!

[@EpoKeins]

Thank you! I only needed the first few minutes. But I've just used the remeining video as a great introduction to the basics of PostgreSQL✌

[@daiyrkanybekov8575]

Great tutorial! I Really appreciate this kind of content, keep it going BRO!

[@SerenityNow_4K_3Dsound]

You are the BEST! Thank you for making it so simple and getting right to the point!!

[@amigoscode]

You welcome

[@de1t0]

Dude, you teach awesome and you're awesome!

[@ddon375]

Thanks Amigoscode this video solved the problem i have been having for over an hour

[@user-kn6vr7el8y]

Great video! Today the PostgreSQL is so simple to install, that's awesome!

[@amigoscode]

Thanks buddy

[@julianb.8749]

thank you man! i was very stress with this until now. x)

[@x7331x]

Great introductory video, thank you so much !

[@bertinopetchiho8407]

Thank you for this amazing introduction video. Very good start for beginners.

[@godwinokache5803]

Thanks for this educative video, looking out for more of this. Once again, thank you very much.

[@farawayfara]

This was extremely helpful. Thank you!!

[@alpstinger5083]

Thanks mate! This was really helpful.

[@barbara2268]

Thank you, that was really useful!

[@roshansapkota4738]

thanks you so so much..helped me get out of the problem at the moment

[@mugofmm7476]

Amazing - very clear and down to the point. Keep it up ;-)

[@andrewm6407]

This video was really helpful! Thanks for uploading

[@amigoscode]

You welcome buddy

[@erdooungwa7660]

Great video. I finally now understand postgresql through this tutorial.

[@amigoscode]

Awesome. I am glad it benefited you

[@techture]

Excellent tutorial! Thank you so much :)

[@jaylee5252]

This was super helpful, thank you 🙂

[@Lucy-sm4ji]

This was so helpful, thank you!

[@tily5939]

Great video! Still works from 3 years ago. Looks like PostgreSQL isn't too different my MySQL, at least on the basic level.

[@DigitalEmma1]

Insightful and very helpful , especially now that i'm new to database

[@amigoscode]

Thanks Seun

[@kav5906]

Hands down the easiest video to follow, I should have looked here first rather than reading docs and blogs. Side note - setting up most things on windows is becoming complex or maybe it's just that I haven't done that in awhile.

[@elidvenega3017]

Thanks men for this lesson.

[@Tejas-zx7ie]

Dude, love your way of explaining things. Make more videos! ♥ from India.

[@amigoscode]

Thanks I will

[@konstantinshmarin2676]

And one! I have not seen course about last Maneger PostgreSQL. I think - you really good teacher =)

[@amigoscode]

Thanks buddy

[@svyatoslavsemochko6397]

Pretty easy to understand tutorial thanks:)

[@amletomonacelli22]

New subscriber bro, amazing video.

[@shohruhsafarov1645]

Thank you brother, Alloh rozi bolsin!

[@chrisrodgers6813]

Super helpful and easy to follow. Thank you!

[@amigoscode]

you welcome

[@milroyshumba7728]

amazing work , really helped a lot

[@jonlbs7]

AWESOME Tutorial.. Thank you !!

[@Omar_Muhammad]

Thanks, that video helps me a lot.

[@jaymo2024]

I finally figured out after struggling with permission error 16:56. 1. Go to file location 2. Right click on the file > choose properties 3. Security 4.Choose your user name > Edit 5. Choose your user name again 6. Under permission for users > Make sure it has full control > Apply > Ok 7. After allowing full control go to postgresql shell \i 'C:\\Users\\computernamegoeshere\\Desktop\\filename.sql'; Best of luck and make sure to use one single quote surrounding the file location plus double back slashes!!!!!!!

[@buka.a]

I love this course so much

[@carlosrangel4500]

Awesome dude, thanks for this :)

[@positivepower2879]

Excellent content. Thank you!

[@emmanuelogunmoroti3348]

Thank you, this video is a life saver

[@mrpikachuyt7973]

Great video, thank you for the help :)

[@AlexRussian92]

Awesome video, thank you so much

[@he132]

thanks, this was helpful

[@bigmonster1277]

Big help thank you so much!!!

[@sachinmaharjan6398]

nice video and it helped me a lot, thank you sir.

[@amigoscode]

I am glad you enjoyed.

[@moviofootgame8726]

Thank You Man!!!

[@Mahesh-gq7fm]

The tutorial is very good and useful

[@tongyu-ph4mo]

Thank you so much!😋

[@cyberguide_in]

Quite helpful. thanks a lot

[@vitia2010a]

Thanks for the information

[@piotrboczar7967]

that was useful, thank you.

[@alickcampbell8915]

Very good tutorial!

[@Rachel_codes]

very helpful video for beginners

[@ex-wife83]

THANK YOU!!!

[@apocalypseb7x]

Thanks! Amigos!!!

[@techture]

Hello my friend! Do you have any videos about connecting DBeaver to PostgreSQL? Thanks so much!

[@william_shokhan]

Really thanks guy

[@lucacaputo2465]

Thank you!

[@dreamchaser8365]

Good work my brother

[@ravenhooper9263]

Loved the video. Do you have any video on connecting psql to an application. I got stuck on connecting it to my app

[@sudomakes]

thanks man!

[@kevinidoma545]

Thanks bro!

[@Romain35BoB]

Merci mon pote !

[@yogialexiusn4130]

thank you amigos

[@danielswearson1360]

This is really good

[@shiblyaziz4528]

Thank you so much

[@vaggelismanousakis6147]

Is there a way to connect Postgres with C# Windows Forms ? I have been struggling past couple of days to do so. Any helpful videos ?

[@athmanmtingwa8896]

Thanks. You are really good.

[@amigoscode]

Thanks buddy

[@JackJones-uj9fh]

you are awesome good job

[@prphawke]

thank you, very helpful

[@amigoscode]

You welcome

[@manu-singh]

I'm impressed that he uses insert key, personally i hate it !! But yeah, command prompt is one it is useful i agree.

[@jamshidganiev2818]

@amigoscode, When I write help in the terminal, Korean words are coming out(I live in South Korea). HOW CAN SET THE LANGUAGE TO ENGLISH?

[@oguzkarademir1441]

Thank you so much :)

[@chio3112]

Great video!

[@root1996]

Thank you very much ❤💕👍🎁

[@wesamhamed1663]

that's great.thanks so much

[@amigoscode]

You are welcome Wesam

[@jonathanndawula8584]

Good Job Bro 👍

[@MrGamislife]

thank you so muchhhh

[@IZE85]

Thanks, mate! ;)

[@nguyenvanloc3744]

thank you so much

[@cristianriosh]

Hello! Why is the port of pgadmin 49998, if when installing it was left by default 5432? thanks in advance

[@TehPobo]

looks good bruvva

[@pauliusstuksys5158]

thank you sir.

[@zhangmr7955]

I m always using Windows system. Seems that I must be forced to give up PG. I tried anything what you mentioned but cannot execute test-# \i even once. BTW, I have no idea if the scripts typping error appears. It seems I must restart the coding again and again. For a newbie, it seems very unefficient to learn.