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 👊🏾
Пікірлер: 235
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!!
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
5 жыл бұрын
Thanks buddy. I haven't used Windows for almost 10 years now
@waheedafolabi6264
4 жыл бұрын
Worked. Thanks for the insight, @Nicholas and great video @Amigoscode
@atanupaul5327
4 жыл бұрын
the '/' is not working \i C:/Users/Atanu Paul/Desktop/test1.sql; this is the command still shows permission dennied why???
@extremepillows
4 жыл бұрын
@@atanupaul5327 it works for me tho
@shobhitsharan2027
4 жыл бұрын
thanks, Man, I was stuck on this for long
I was looking for a new and relevant tutorial and finally have found it! Thank you so much!
@amigoscode
4 жыл бұрын
You welcome again
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
2 жыл бұрын
Definitely Nelson you are the best, Thanks for all. Keep up
Awesome video. Straightforward, easy to follow, and complete. Really appreciate it.
@amigoscode
5 жыл бұрын
Glad you liked it
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!
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.
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
2 жыл бұрын
Thank you sir it worked;)
@vude123
2 жыл бұрын
many thanks sir
@uchejames409
Жыл бұрын
Thank you so much. It worked for me.
@rudra2036
6 ай бұрын
thank u thank u
without a doubt the best, most complete tutorial for anything I have seen on yt. Thank you very much!
I am new to PGres and this beginner tutorial of yours is very helpful !! Thanks a bunch 🙏
Direct, concise and to the point. Thanks for a great introduction. Subscribed and will check out your other courses.
@amigoscode
4 жыл бұрын
Glad it was helpful!
Wow! such an amazing way of explaining...everything was so clear...step by step..thank you so much!
Thank you Amigo, you have fantasticly succinct and easy to understand tutorials! I liked and subscribed (with notifications).
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
Great content and easy to follow. Fantastic video mate!
Thank you very much dear Nelson, everything worked with the terminal and also with pgAdmin4. Many many thanks!
You are the BEST! Thank you for making it so simple and getting right to the point!!
@amigoscode
4 жыл бұрын
You welcome
Great video! Today the PostgreSQL is so simple to install, that's awesome!
@amigoscode
4 жыл бұрын
Thanks buddy
Thank you so much! Brilliant explanation of the topic - it helped massively!
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✌
This video was really helpful! Thanks for uploading
@amigoscode
5 жыл бұрын
You welcome buddy
Amazing - very clear and down to the point. Keep it up ;-)
thank you man! i was very stress with this until now. x)
Nelson, you are the best. Keep the good work. This video helped me understand command line syntax.
This was extremely helpful. Thank you!!
Excellent tutorial! Thank you so much :)
Thanks Amigoscode this video solved the problem i have been having for over an hour
Great video. I finally now understand postgresql through this tutorial.
@amigoscode
4 жыл бұрын
Awesome. I am glad it benefited you
Dude, love your way of explaining things. Make more videos! ♥ from India.
@amigoscode
4 жыл бұрын
Thanks I will
Thank you for this amazing introduction video. Very good start for beginners.
Thank you brother, Alloh rozi bolsin!
Great tutorial! I Really appreciate this kind of content, keep it going BRO!
And one! I have not seen course about last Maneger PostgreSQL. I think - you really good teacher =)
@amigoscode
5 жыл бұрын
Thanks buddy
Great video! Still works from 3 years ago. Looks like PostgreSQL isn't too different my MySQL, at least on the basic level.
Thanks mate! This was really helpful.
Dude, you teach awesome and you're awesome!
Insightful and very helpful , especially now that i'm new to database
@amigoscode
4 жыл бұрын
Thanks Seun
Great introductory video, thank you so much !
AWESOME Tutorial.. Thank you !!
Thanks for this educative video, looking out for more of this. Once again, thank you very much.
Pretty easy to understand tutorial thanks:)
This was so helpful, thank you!
amazing work , really helped a lot
I love this course so much
Awesome dude, thanks for this :)
Thank you, that was really useful!
thanks you so so much..helped me get out of the problem at the moment
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.
Super helpful and easy to follow. Thank you!
@amigoscode
4 жыл бұрын
you welcome
Excellent content. Thank you!
This was super helpful, thank you 🙂
Great video, thank you for the help :)
Big help thank you so much!!!
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!!!!!!!
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
4 жыл бұрын
google is your best bet. whats how I do everything
Awesome video, thank you so much
Thank you, this video is a life saver
Thanks, that video helps me a lot.
New subscriber bro, amazing video.
that was useful, thank you.
Thank You Man!!!
Thanks! Amigos!!!
Thanks men for this lesson.
nice video and it helped me a lot, thank you sir.
@amigoscode
5 жыл бұрын
I am glad you enjoyed.
Hello my friend! Do you have any videos about connecting DBeaver to PostgreSQL? Thanks so much!
Thank you so much!😋
thanks, this was helpful
Quite helpful. thanks a lot
Great video!
jazakallahu hayran Akhi!!!!!
The tutorial is very good and useful
Thanks for the information
looks good bruvva
THANK YOU!!!
thanks man!
Merci mon pote !
that's great.thanks so much
@amigoscode
4 жыл бұрын
You are welcome Wesam
Very good tutorial!
This is really good
Thank you!
Really thanks guy
Loved the video. Do you have any video on connecting psql to an application. I got stuck on connecting it to my app
Thank you so much :)
thank you, very helpful
@amigoscode
4 жыл бұрын
You welcome
Thanks, mate! ;)
Thanks bro!
Thanks. You are really good.
@amigoscode
4 жыл бұрын
Thanks buddy
Some people say "you know" a lot. Some go with "uhm", this one uses "pretty much" xD Btw, video was pretty much useful.
@amigoscode
4 жыл бұрын
lol thanks
I'm impressed that he uses insert key, personally i hate it !! But yeah, command prompt is one it is useful i agree.
Good work my brother
thank you amigos
thank you so muchhhh
A good tutorial.
very helpful video for beginners
you are awesome good job
Thanks big time.
@amigoscode
4 жыл бұрын
you welcome
Thank you so much
Good Job Bro 👍
Thanks Man
thank you so much