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...
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

[@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.

[@Name-qt6jv]

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

[@amigoscode]

You welcome again

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

[@timjohnston6072]

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

[@amigoscode]

Glad you liked it

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

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

[@fxgraphicslive]

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

[@changofaceanimations5402]

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

[@amedeekreuzer9190]

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

[@antonyrichard369]

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

[@de1t0]

Dude, you teach awesome and you're awesome!

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

[@ddon375]

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

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

[@mussiekebede2575]

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

[@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✌

[@konstantinshmarin2676]

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

[@amigoscode]

Thanks buddy

[@victoria19162]

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

[@dimplesantoshi8561]

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

[@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.

[@amletomonacelli22]

New subscriber bro, amazing video.

[@user-kn6vr7el8y]

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

[@amigoscode]

Thanks buddy

[@andrewm6407]

This video was really helpful! Thanks for uploading

[@amigoscode]

You welcome buddy

[@julianb.8749]

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

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

[@loam]

Some people say "you know" a lot. Some go with "uhm", this one uses "pretty much" xD Btw, video was pretty much useful.

[@amigoscode]

lol thanks

[@jeevantha123]

Great content and easy to follow. Fantastic video mate!

[@godwinokache5803]

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

[@DigitalEmma1]

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

[@amigoscode]

Thanks Seun

[@shohruhsafarov1645]

Thank you brother, Alloh rozi bolsin!

[@adewaleayeni-bepo2072]

Great video. Where did Sublime come from in 15:40?

[@lisacalhoun8080]

I have the same question. I'm new to PostgreSQL and have been out of the coding game for about 10 years (and a LOT has changed, I'm certain!).

[@jpanPirate]

Thanks men for this lesson.

[@daiyrkanybekov8575]

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

[@tily5939]

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

[@barbara2268]

Thank you, that was really useful!

[@jaylee5252]

This was super helpful, thank you 🙂

[@SerenityNow_4K_3Dsound]

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

[@amigoscode]

You welcome

[@x7331x]

Great introductory video, thank you so much !

[@chrisrodgers6813]

Super helpful and easy to follow. Thank you!

[@amigoscode]

you welcome

[@connorg9437]

At 11:59 how did you duplicate the previous inserts instantly??? Would be awesome if you PLEASE commentary these helpful shortcuts whenever you implement them.

[@AntonioGomez-og8sz]

up arrow, will copy the most recent line, can also continue to up arrow and get all the recent commands

[@bertinopetchiho8407]

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

[@roshansapkota4738]

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

[@buka.a]

I love this course so much

[@erdooungwa7660]

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

[@amigoscode]

Awesome. I am glad it benefited you

[@Omar_Muhammad]

Thanks, that video helps me a lot.

[@alpstinger5083]

Thanks mate! This was really helpful.

[@zlucyz1]

This was so helpful, thank you!

[@dreamchaser8365]

Good work my brother

[@serahnderi]

Would have loved to see a successful case of sublime connection. I keep getting permission denied on my Windows laptop.

[@farawayfara]

This was extremely helpful. Thank you!!

[@ravenhooper9263]

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

[@Rachel_codes]

very helpful video for beginners

[@emmanuelogunmoroti3348]

Thank you, this video is a life saver

[@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.

[@mugofmm7476]

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

[@apocalypseb7x]

Thanks! Amigos!!!

[@techture]

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

[@carlosrangel4500]

Awesome dude, thanks for this :)

[@adilkhanabdrashov7507]

jazakallahu hayran Akhi!!!!!

[@Tejas-zx7ie]

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

[@amigoscode]

Thanks I will

[@svyatoslavsemochko6397]

Pretty easy to understand tutorial thanks:)

[@milroyshumba7728]

amazing work , really helped a lot

[@techture]

Excellent tutorial! Thank you so much :)

[@jonlbs7]

AWESOME Tutorial.. Thank you !!

[@positivepower2879]

Excellent content. Thank you!

[@he132]

thanks, this was helpful

[@Mahesh-gq7fm]

The tutorial is very good and useful

[@sachinmaharjan6398]

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

[@amigoscode]

I am glad you enjoyed.

[@moviofootgame8726]

Thank You Man!!!

[@andrewm6407]

Why do you recommend that we use the command line rather than the GUI? I'm not saying I disagree at all but I just wondered. If anyone has opinions on this, please go ahead. Thanks

[@amigoscode]

You can use GUI but if you want to learn the database and have full control then terminal is your best friend. I have used Datagrip in the past and its the best GUI client out there, but its not free.

[@amigoscode]

You can use GUI but if you want to learn the database and have full control then terminal is your best friend. I have used Datagrip in the past and its the best GUI client out there, but its not free.

[@Derekstefan]

I got an error at: 7:09. It said psql error: could not connect to sever: fe_sendauth: no password supplied.

[@deepaksangroha]

Amazing work, Nelson !! Is there any video of you doing High Availability setup of PostgreSQL on Windows Server ? If not, any good source ? :)
thank you.

[@amigoscode]

google is your best bet. whats how I do everything

[@tongyu-ph4mo]

Thank you so much!😋

[@mrpikachuyt7973]

Great video, thank you for the help :)

[@alickcampbell8915]

Very good tutorial!

[@jonathanndawula8584]

Good Job Bro 👍

[@bigmonster1277]

Big help thank you so much!!!

[@wesamhamed1663]

that's great.thanks so much

[@amigoscode]

You are welcome Wesam

[@AlexRussian92]

Awesome video, thank you so much

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

[@william_shokhan]

Really thanks guy

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

[@Romain35BoB]

Merci mon pote !

[@cyberguide_in]

Quite helpful. thanks a lot

[@vitia2010a]

Thanks for the information

[@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.

[@IZE85]

Thanks, mate! ;)

[@VGLV888]

What is a shortcut to copy previous line in shell?
Not to type again UPDATE TABLE person...

[@VGLV888]

It's up arrow key. :)
I got it. Thanks anyway. Great video.

[@JackJones-uj9fh]

you are awesome
good job

[@asmaamohammad6004]

I am trying to install postgresql
But there is an error:
There has been an error.
Error running C:\Windows\Systems32\icacls "C:\Users\a.m.s\AppData\Local\Temp/postgresql_installer_6d4885e97d"/T/Q/grant"öa-m\a.m.s:(OI)(CI)F":?a-m\a.m.s:No mapping between account names and security IDs was done
Can you help me please?

[@ibrahimasall8939]

Hi thanks for your video please can you explain me how to change the encoding on UTF8 I'm in French country .

[@58_ce_priyawadile32]

Can you please make a video on how to change the postgres password

[@yogialexiusn4130]

thank you amigos

[@yangyue2791]

16:37, My windows 10 Dell laptop faces the same problem. Then, I solved the problem by using forward slah / for address of the file to run.

[@SVGPRO]

When I run pgAdmin 4 i get a GUI not a web browser window? How do I access service on web?

[@ex-wife83]

THANK YOU!!!

[@root1996]

Thank you very much ❤💕👍🎁

[@piotrboczar7967]

that was useful, thank you.