skip the install part if you already have the setup in place: 12:12
@Yaroslav5194 жыл бұрын
Thank you, Daiana!
@supriyosarkar18063 жыл бұрын
wish I saw your comment at the beginning . Seeing your comment after the vdo completion XD
@programingabo45242 жыл бұрын
Thank you!!
@rupam81073 жыл бұрын
Finally Walter White comes to teaching SQL
@purswanitarun2 жыл бұрын
Almost sounds like Bryan too 🤒
@zuriglr2 жыл бұрын
Only for this string it was worth to scroll the comments!
@leogodofnone27062 жыл бұрын
XD
@EdwardMendoza4 жыл бұрын
To skip the install and theory, go straight to: 18:30
@petercampbell16484 жыл бұрын
Awesome! It's so difficult to find tutorials that don't spend most of the time explaining the product benefits!
@Codemycom4 жыл бұрын
Glad you liked it!
@JK-nx1wd8 ай бұрын
This is beyond good. Every time i get stuck with something and look online, up you pop. Thanks loads as have been using mysql, now switching to postgresql to use ArrayField and hit with another new admin setup to tinker with and get familiar with.
@Codemycom8 ай бұрын
glad you liked it!
@karmendurbin3 жыл бұрын
Skip to 18:33 if you already have everything installed and already know what a database is...
@gurunathrao29852 жыл бұрын
This is a good introductory tutorial for PostgresSQL and the tools which enforce it. Good job here Codemy.
@Codemycom2 жыл бұрын
Glad you enjoyed it!
@SisiNifemi912 жыл бұрын
I just started my journey into data and I stumbled on your video, it was a good watch ..... thank you for putting dis out there 🤗🤗🤗
@Codemycom2 жыл бұрын
Glad you enjoyed it!
@jig10564 жыл бұрын
nice work.. this was very helpful. At first glance, PGAdmin looks very complicated. As you mentioned all of the options under database can be very overwhelming. I really wanted to know how to use the tool as an IDE. Thanks for the insight.
@Codemycom4 жыл бұрын
Glad you found it useful!
@RishiRaj-wq7xd Жыл бұрын
thanks a lot for quick and comprehensive tutorial.
@Codemycom Жыл бұрын
Welcome!
@RiddhishThakore Жыл бұрын
How can I see the datatype length like (VARCHAR(30)) along with attribute name in table.......
@masibulelemsayi91545 жыл бұрын
Thank you sir. Great video.
@Codemycom5 жыл бұрын
You're welcome!
@pkop44 жыл бұрын
starts at 3:26
@Codemycom4 жыл бұрын
Interesting suggestion.
@pushkardey4 жыл бұрын
Someone give this (wo)man a Like!
@kushagraacharya62793 жыл бұрын
if you are not able to save the input data in table by clicking the icon try pressing F6 32:29
@afqaimn51242 жыл бұрын
thanks. you save me
@CrowLive3 ай бұрын
Thank you!
@mariaheirich27803 жыл бұрын
What is the rule for when the parenthesis should be used? Also, why the double quotes in one place and the query and single quotes in another part? Is there a rule for this as well?
@sudeshfernando97732 жыл бұрын
such a good and descriptive tutorial.. Love it!!
@Codemycom2 жыл бұрын
Thanks!
@shahilshrestha37002 жыл бұрын
thank you sir love from Nepal
@Codemycom2 жыл бұрын
Welcome!
@jassonjoshua2 жыл бұрын
Perfect! All I needed!
@ltomic01904 жыл бұрын
Informative and easy to understand. Thank you!
@Codemycom4 жыл бұрын
Glad it was helpful!
@joselitoreyes71872 жыл бұрын
How do I input: films that start with the letters S and T? Thank you for your help.
@PremKumar-er8fv2 жыл бұрын
Im trying to use pgadmin 3 , postgre sql in ubuntu 18.4 version ... I'm getting error as " Access to database denied" While I'm giving passwrd and user in pg admin
@saidsaid-nn1qk4 жыл бұрын
Thank you teacher !
@Codemycom4 жыл бұрын
You're welcome!
@shubhamanbhule61233 жыл бұрын
I did'nt understand 31:21 part of how to import data and save file can u please explain it.
@Codemycom3 жыл бұрын
Didn't I show how to do it in the video?
@conradlewis56895 жыл бұрын
Very well done! Keep up the good work!
@Codemycom5 жыл бұрын
Thanks! Glad you enjoyed it!
@ToddsDiscGolf2 жыл бұрын
when i click import/export i get "utility not found. please setup binary path in preferences" or something. In preferences I put c:\Program Files\PosgresSQL\15\bin for the binary path but it says it can't find the 4 files it's looking for there
@gabrielgomes68763 жыл бұрын
Really enjoyed this course
@Codemycom3 жыл бұрын
Thanks!
@albinmiftari18322 жыл бұрын
Postgres 10 in the video, in 14 you need to write "INSERT INTO public.customers" so skip the "" at 34:04
@JBGecko13yt5 жыл бұрын
Great video! I will be sharing it and adding it to one of my play lists
@Codemycom5 жыл бұрын
Glad you liked it!
@AmandeepSingh-ip4oo7 ай бұрын
Thank you for the video. My PGADMIN does not open in a browser. Will that be fine.? I am using the latest version of postgresql. I am a complete newbie. Kindy guide.
@Codemycom7 ай бұрын
that's fine
@Orokusaki19862 жыл бұрын
using newest pgadmin... the save icon doesn't seem to be doing anything for me, so after I added Mary Brown, I went back and my other data wasn't there... =-\
@Orokusaki19862 жыл бұрын
I figured it out via stack overflow - use the next icon over, the 3 disk shaped "Save data changes" button, or F6
@CR-lz5yx3 жыл бұрын
Awesome👍
@Codemycom3 жыл бұрын
thanks!
@sandeepkumar-bh4de3 жыл бұрын
If sql coding dialog box move in other place then how i set it on its default place?
@thejesudayan77862 жыл бұрын
Hi , I can't edit the data after I started a new database. In view data it is showing a lock symbol in all oclumns
@ArtLoverDaiana4 жыл бұрын
PGadmin overview 18:32
@omofolawaalimi-adeniran6312 жыл бұрын
Thanks John, so enlightening!
@Codemycom2 жыл бұрын
welcome!
@frikbrits63353 жыл бұрын
Nice video, ........ but what happens if you can not connect to your existing database on Linux. And haw to do if your data is on a user defined disk ??
@ЛинаКулагина-и1г3 жыл бұрын
Спасибо! Очень хорошо рассказано, понятно что и как делать !!!!
@ilyalain55164 жыл бұрын
Hello, thank you for making this video!! I do have a problem. This tutorial was going great for me until 19:50 where I realised i dont have the plus sign beside the 'Server' to continue on to create a database :(
@Codemycom4 жыл бұрын
Weird...what did you do differently from my videos?
@ilyalain55164 жыл бұрын
no :( I did follow everything. I am on MacOS server and even tutorials for macOS installations had the plus sign. Will try to google and search around :’)
@Shubham-tq1fz4 жыл бұрын
I also faces same issue, go to create server option type localhost in host and you user name and password and click on the save
@arunbeckham83844 жыл бұрын
did you got rectified bro?
@GodofChookie4 жыл бұрын
same here
@Mahesh-gq7fm4 жыл бұрын
Tnk u. superb. easy to understand
@learningchannel885 жыл бұрын
Hi There I am having issues setting up my access to my works database through my mac. I think the tunnel is the issue. I am not able to find information on the issue. Do you have any recommendations?
@Codemycom5 жыл бұрын
In the video, I talk about using one of three different connectors (if one doesn't work). Did you try all three?
@greengrer3 жыл бұрын
Well explained
@Codemycom3 жыл бұрын
Thanks!
@JosephOjebode Жыл бұрын
Can you PLEASE do a video on how to create a cluster with a different user different from default user (POSTGRES)
@aninehartog39503 жыл бұрын
It is impossible to work with pgAdmin4. It is so slow. I am trying to create the database and is now waiting for 13 minutes for the Create Database screen to show me this field that needs to be entered. I am working on a Windows 10 PC and is connecting to the localhost. I am doing something wrong?
@mishalbisharat40653 жыл бұрын
Hi John I cannot add my data in the colums ?
@aykutsirma42604 жыл бұрын
really nice tutorial and clean explanation
@Codemycom4 жыл бұрын
Glad you liked it!
@aykutsirma42604 жыл бұрын
@@Codemycom John I have a question to you and I will be very happy if you reply. I try to insert real time data to my database and what I want to do is this: I had created a postgres database with two columns for testing with double data type with 20 rows as Null at the beginning; but when I use insert, the data is being inserted from the 21st row which it doesn't insert from the first row. To insert the incoming real-time data to specific row (starting from 1st row to infinite) to the a specific column location in the PostgreSQL. I feed this real time data from Matlab too. Thus, is there a specific command for what I want to achieve in PostgreSQL? thank you.
@sylveriakimbi24674 жыл бұрын
This is a great tutorial.
@Codemycom4 жыл бұрын
Thanks!
@johanapolinarioveliz67543 жыл бұрын
My autocompletion ctrl + space doesn't work, I am using Chrome, Windows 10, and I check preferences into the pgadmin and the autocomplete is True. I don't know what is wrong. :( Could you help me, please Codemy?
@hanadraskovic68393 жыл бұрын
hm, i installed everything and when i try to start pdAdmin it just freezes and reports Fatal Error. I am on Windows 10 pro. i tried everything i could find online, mostly on stackoverflow and nothing helped? i unnstalled pgAdmin only from the whole postgres installation and installed pgAdmin separately. that didn't help eather. i added the sqlite3 path to my env paths and it only gave me another error - sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
@vishnusingh41183 жыл бұрын
New table created at 24:33. Finally! Pheww!
@Codemycom3 жыл бұрын
lol
@fadligababe36274 жыл бұрын
Hey man, I want to save a PGadmin file, but then nowhere does the PGADMIN appear fro me to save it to. If I click save it saves it to google chrome browser. Please help
@Codemycom4 жыл бұрын
what file do you mean?
@fadligababe36274 жыл бұрын
@@Codemycom I just want to save my pgadmin work, if I click on save, and I want to choose a location, it does not allow me, basically it's disabled (the save button)
@natalieclapp2615 Жыл бұрын
Quick question!!!! I had my pgadmin all up and running and then one time upon opening I lost my browser tab ,when I click on add server and nothing happens. I deleted all files and my Postgres that I was running on it… and reinstalled. Reset layout etc Nothing ! I was told to change ip address ….. I am sooo lost any suggestions?
@Codemycom Жыл бұрын
Not sure what you mean...but delete everything, watch the video again, follow along exactly.
@reggiessmith77073 жыл бұрын
Thanks for your help! What about Mac users?
@kgaurav353 жыл бұрын
maybe watch Postico tutorials :))
@testeteste2965 жыл бұрын
Thank you very much. Couldn't find it anywhere else.
@Codemycom5 жыл бұрын
Glad you liked it!
@techgix2 жыл бұрын
nice tutorial. but, when i click on server, it doesn't show me the postgres 13. i created a database in control panel but, i can't find even the postgres 13 on my server. the server is empty. please sir i need your help.
@setarehzare37 Жыл бұрын
thank you!
@Codemycom Жыл бұрын
Welcome!
@MeeMawBarb2 жыл бұрын
Hi, I loved this video but it didn't go quite far enough for me. I have 2 tables that are "related" to each other and need to connect them. Do you have a tutorial on that? Thanks!!
@Brian-xb7qv Жыл бұрын
look up joins
@MeeMawBarb Жыл бұрын
@@Brian-xb7qv can you give me a LINK to the video please? Thanks!!
@bolajigiwa21173 жыл бұрын
Thanks for simplifying the lesson. It really helped. Please, how do I save my sql script in case I wanna come back to it later to continue?
@Codemycom3 жыл бұрын
What do you mean, just save it. Click the file>save button on the text editor.
@ankushtagore4299 Жыл бұрын
Walterwhite is teaching Postgre, I can't refuse to watch in one go
@Codemycom Жыл бұрын
Ha!
@shawnbeans73894 жыл бұрын
can i use this for django?
@manishkhatrichhetri31502 жыл бұрын
I don't see any coupon code. Can you provide coupon code so that I can buy from Udemy?
@Codemycom2 жыл бұрын
JOHN_ELDER25
@bhavinmoriya92163 жыл бұрын
Hi how could I increase the size of the font of the database tree pannel in pgadmin4?
@Codemycom3 жыл бұрын
no clue
@tyrrelldavis99195 жыл бұрын
Having some trouble creating extra rows The id is a primary key, what am I doing wrong? This syntax seems correct INSERT INTO employees (id, name) VALUES (1, "John Doe") Edit: id was type "int" not a serial Been looking all over , postgres docs, stsckoverflow, etc
@pdx964 жыл бұрын
What's the error message? Is 1 already taken? Primary keys cannot be used by another row.
@caseyco217073 жыл бұрын
Great informative Video, really appreciate your work!
@Codemycom3 жыл бұрын
Thanks!
@najibadam5 жыл бұрын
Great work! How can i find the continue of this lesson in udemy? thanks
@Codemycom5 жыл бұрын
You can find it here at discount today: bit.ly/2MIpwJh
@joonaschuk20164 жыл бұрын
Hi John! I have a problem. I'm trying to load a sample database by restoring it on pgAdmin and once I choose the .tar file and hit "restore" I get "Failed (exit code: -6)" message. Any idea what's wrong and how to fix this? Tried Googling these exit codes, but I can't find anything.
@Codemycom4 жыл бұрын
tar files aren't database files. Tar files are zip files...you have to unzip it first, then load the unzipped (or I guess un-tarred) file.
@joonaschuk20164 жыл бұрын
@@Codemycom Thanks for the reply. Still no luck though. It was so misleading, because even the pgAdmin says in the restore window that the format would be "custom or tar". I was reading this PostgreSQL tutorial about loading a sample database and there it was .tar-file that was used.
@aldystudent4 жыл бұрын
Wondering if anyone has this problem as well; So, I still running my Windows on the version 8.1 I tried to install the PostgreSQL following the instruction on the video. However, I got a warning message just before the progress bar finish. From what I see, it happens when it's installing the database cluster. About the warning messages: 'Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed.' Been trying looking for the solution on the web, but none actually help me solve this issue. I am wondering if you can help me fix this problem?
@aldystudent4 жыл бұрын
After spending another hour to find the fix, I am happy to inform you that I managed to install it without any error.
@shaharharel60882 жыл бұрын
thank you for the video. very helpful! cheers from Israel ✌
@Codemycom2 жыл бұрын
Glad you enjoyed it!
@akanshajain29384 жыл бұрын
Hi, Actually i want to restore a file in Pgadmin 4 but it is not restoring as required. can you let me know if a file in preview format(Notepad) be restored in Pgadmin 4 or not ? If Yes , How? OS - Windows 10 , PostgreSQL 10 , 32 Bit
@Codemycom4 жыл бұрын
Sure, but without knowing your situation, I couldn't guess.
@akanshajain29384 жыл бұрын
@@Codemycom Can you let me know a mail id on which I can contact and elaborate my issue?
@harshithareddy49114 жыл бұрын
Hi there , I couldn’t find PostgreSQL under server though I installed both . Can someone help me with this?
@Codemycom4 жыл бұрын
Try reinstalling it. Watch the video again to see what you missed
@leenathorat16244 жыл бұрын
I was Just getting pretty surprised.. The explanation before 22.00 it was the same explanation given by my Lecturer last year...but fortunately I came Across this channel because unfortunately my Lecturer is changed...
@Codemycom4 жыл бұрын
Ha
@arturmelosantiagoferreira1575 жыл бұрын
When I started the pgAdmin4 doesn' t have any preview server. What do I do? (ps: sorry if I wrote wrong, my english is bad)
@tyrrelldavis99195 жыл бұрын
Make sure you selected postgresql server on port 5432 on install Should open up localhost connected to pgadmin I can help you if you're on discord
@shanildajones62082 жыл бұрын
How come you didn’t use the postgresql shell
@Codemycom2 жыл бұрын
why would I?
@khalidelmoussaoui21753 жыл бұрын
hello Teacher, I need your help , I want to create an electronic paper archiving server but have no idea If you can give me some advice or help me
@Codemycom3 жыл бұрын
No sorry
@balajinatarajan91252 жыл бұрын
how to import sharepoint data
@no_deploy_friday4 жыл бұрын
Thank you very much
@Codemycom4 жыл бұрын
You are welcome
@jameshagood23735 жыл бұрын
I am having an issue with foreign keys in postgresql. I have an application that has user registration/login and when u login you post a new article. I have two tables one table is users and one table is articles. The users table has 3 columns userid, password, username. The articles table has 6 columns. Articleid, dateupdated, datecreated, body, title, and userid. When I post an article after a user is logged in I dont get the corresponding userid with the article that is posted. Userid column in the articles table just says null. I made a foreign key called article_userid_foreign_key with local column set to userid reference the public.users table referencing the userid. I am using node is I have let userId = req.session.user.userId; the other columns are getting data like body, title, ect. The userid column under articles is just getting back null. Can anybody help ke with this
@Codemycom5 жыл бұрын
I'd post your code and question at stackoverflow and ask for help there. Without the code it's hard to help and you can't really post the code here in easily readable format.
@jameshagood23735 жыл бұрын
@@Codemycom github.com/cardfaux/postgreSQL?files=1 I put it on github. I've posted questions everywhere and 8 have emailed professors at the local community college here where I live In bumb fuck Alabama and they said that postgreSQL databases was out of their expertise. The problem could be my pgAdmin set up but I have changed all of it multiple times
@tosh3692 жыл бұрын
Skip the PostgreSQL install and the explanation of what a database is by going to 18:28
@arianitonline87482 жыл бұрын
elephant vs dolphin?! tough choice
@maulikpatel39753 жыл бұрын
My personnel favorite - "FLAT_EARTH_GUY" !!
@Codemycom3 жыл бұрын
Ha
@Stiefel19904 жыл бұрын
Can anyone answer the following question: How do I process the input of a form and insert the values into multiple related tables with Node.js and Postgresql?
@undercrackers564 жыл бұрын
Big question! If you want to update two or more tables at the same time then you need to create stored procedures. The procedure (like a NodeJS function) takes a number of parameters that will be written to tables. Alternatively you can write a number of database update statements and get NodeJS to handle each table update. (Not good practice.) Either way you will need to add PostgreSQL database functionality to your NodeJS code.
@Stiefel19904 жыл бұрын
@@undercrackers56 Many thanks for your detailed answer. Can you give me a few technical terms I should deal with?
@mostafatagmouti3384 жыл бұрын
great work perfect tutorial thank you.
@Codemycom4 жыл бұрын
Glad you found it useful!
@DamnBoii1234 жыл бұрын
All of his tutorials are great
@Codemycom4 жыл бұрын
@@DamnBoii123 Thanks!
@ratmirsusanin54965 жыл бұрын
Thanks!
@Codemycom5 жыл бұрын
Enjoy!
@zachwhite80544 жыл бұрын
Thank you sir.
@Codemycom4 жыл бұрын
You're very welcome!
@joemakulila97584 жыл бұрын
i have intalled postgresql, im now trying to install Dspace
@Codemycom4 жыл бұрын
ok
@johncortenbach35743 жыл бұрын
Hi, I enjoyed watching your video tutorial. Do your courses cover basic instructions consist of using SQL language consist of data query language, data definition, or data manipulation language? I appreciate your feedback. Thank you
@laychivoanvimol58714 жыл бұрын
when i click save,It doesnt automatically assign number 1 to id.why?
@Codemycom4 жыл бұрын
Cuz you did something wrong with your code, I assume...
@1sam2fisher4 жыл бұрын
Look for "postgresql auto increment" on google, I assume that will be enough.
@edwinthompson74024 жыл бұрын
great informative video, much appreciated
@Codemycom4 жыл бұрын
Glad You liked it!
@WaldoTheWombat4 жыл бұрын
You Rock!
@Codemycom4 жыл бұрын
Thanks!
@vaishnavihurde81455 жыл бұрын
what is key difference between postgreSQ and MYSQL
@siweiwu655 жыл бұрын
MYSQL is way better than PostgreSQL, trust me that is true. PostgreSQL query language is so stupid.
@paulonteri5 жыл бұрын
@@siweiwu65 PostgreSQL is very efficient and even used by big companies such as Instagram
@soccerfp4 жыл бұрын
@@siweiwu65 dumbest comment of the year goes to...
@omkars7644 жыл бұрын
it wont let me save after inserting into table
@Codemycom4 жыл бұрын
Did you google the error you're getting?
@swarupsarangi7344 жыл бұрын
click on "Save Data Changes(F6)" icon on the right side of "Save File" icon .
@cloudsystem3740 Жыл бұрын
thanks
@Codemycom Жыл бұрын
Welcome!
@Jaxxy354 жыл бұрын
I had a problem getting past the password requirement but I found this fix online. It gets rid of the need for a password. in folder C:\Program Files\PostgreSQL\9.2\data or C:\Program Files (x86)\PostgreSQL\9.x\data, you'll find the pg_hba.conf text file. Find the following lines: # TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 and change METHOD md5 to "trust" like this: # TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
@EhsanRavana2 жыл бұрын
perfect
@Codemycom2 жыл бұрын
Thanks!
@vaggelismanousakis61474 жыл бұрын
Thinking of buying a course for intermediate level as I have Data Bases(SQL) class in this semester. Thanks for the video!
@Codemycom4 жыл бұрын
Cool!
@ShevchenkoKirill Жыл бұрын
O god, it's Heisenberg!
@Codemycom Жыл бұрын
Ha!
@Sure_Math_Center Жыл бұрын
Cool
@Codemycom Жыл бұрын
THanks
@dilzodbekabdusattorov42043 жыл бұрын
best
@Codemycom3 жыл бұрын
Thanks!
@VegetaZA4 жыл бұрын
Thanks bro!
@Codemycom4 жыл бұрын
Sure thing!
@eskailash4 жыл бұрын
1. how to open pgAdmin is told 2. how to close/shut down pgAdmin is not explain................. ????
@Codemycom4 жыл бұрын
isn't it in the web browser? Close the tab dude
@shafiaziz14833 жыл бұрын
all these tutorials about simple commands in real life you cant import data , the sql never import data it simpl;y shows some error or another