Tap to unmute

Intro To PostgreSQL Databases With PgAdmin For Beginners - Full Course

  Рет қаралды 268,106

Codemy.com

Codemy.com

Күн бұрын

Пікірлер
@ArtLoverDaiana
@ArtLoverDaiana 4 жыл бұрын
skip the install part if you already have the setup in place: 12:12
@Yaroslav519
@Yaroslav519 4 жыл бұрын
Thank you, Daiana!
@supriyosarkar1806
@supriyosarkar1806 3 жыл бұрын
wish I saw your comment at the beginning . Seeing your comment after the vdo completion XD
@programingabo4524
@programingabo4524 2 жыл бұрын
Thank you!!
@rupam8107
@rupam8107 3 жыл бұрын
Finally Walter White comes to teaching SQL
@purswanitarun
@purswanitarun 2 жыл бұрын
Almost sounds like Bryan too 🤒
@zuriglr
@zuriglr 2 жыл бұрын
Only for this string it was worth to scroll the comments!
@leogodofnone2706
@leogodofnone2706 2 жыл бұрын
XD
@EdwardMendoza
@EdwardMendoza 4 жыл бұрын
To skip the install and theory, go straight to: 18:30
@petercampbell1648
@petercampbell1648 4 жыл бұрын
Awesome! It's so difficult to find tutorials that don't spend most of the time explaining the product benefits!
@Codemycom
@Codemycom 4 жыл бұрын
Glad you liked it!
@JK-nx1wd
@JK-nx1wd 8 ай бұрын
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.
@Codemycom
@Codemycom 8 ай бұрын
glad you liked it!
@karmendurbin
@karmendurbin 3 жыл бұрын
Skip to 18:33 if you already have everything installed and already know what a database is...
@gurunathrao2985
@gurunathrao2985 2 жыл бұрын
This is a good introductory tutorial for PostgresSQL and the tools which enforce it. Good job here Codemy.
@Codemycom
@Codemycom 2 жыл бұрын
Glad you enjoyed it!
@SisiNifemi91
@SisiNifemi91 2 жыл бұрын
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 🤗🤗🤗
@Codemycom
@Codemycom 2 жыл бұрын
Glad you enjoyed it!
@jig1056
@jig1056 4 жыл бұрын
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.
@Codemycom
@Codemycom 4 жыл бұрын
Glad you found it useful!
@RishiRaj-wq7xd
@RishiRaj-wq7xd Жыл бұрын
thanks a lot for quick and comprehensive tutorial.
@Codemycom
@Codemycom Жыл бұрын
Welcome!
@RiddhishThakore
@RiddhishThakore Жыл бұрын
How can I see the datatype length like (VARCHAR(30)) along with attribute name in table.......
@masibulelemsayi9154
@masibulelemsayi9154 5 жыл бұрын
Thank you sir. Great video.
@Codemycom
@Codemycom 5 жыл бұрын
You're welcome!
@pkop4
@pkop4 4 жыл бұрын
starts at 3:26
@Codemycom
@Codemycom 4 жыл бұрын
Interesting suggestion.
@pushkardey
@pushkardey 4 жыл бұрын
Someone give this (wo)man a Like!
@kushagraacharya6279
@kushagraacharya6279 3 жыл бұрын
if you are not able to save the input data in table by clicking the icon try pressing F6 32:29
@afqaimn5124
@afqaimn5124 2 жыл бұрын
thanks. you save me
@CrowLive
@CrowLive 3 ай бұрын
Thank you!
@mariaheirich2780
@mariaheirich2780 3 жыл бұрын
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?
@sudeshfernando9773
@sudeshfernando9773 2 жыл бұрын
such a good and descriptive tutorial.. Love it!!
@Codemycom
@Codemycom 2 жыл бұрын
Thanks!
@shahilshrestha3700
@shahilshrestha3700 2 жыл бұрын
thank you sir love from Nepal
@Codemycom
@Codemycom 2 жыл бұрын
Welcome!
@jassonjoshua
@jassonjoshua 2 жыл бұрын
Perfect! All I needed!
@ltomic0190
@ltomic0190 4 жыл бұрын
Informative and easy to understand. Thank you!
@Codemycom
@Codemycom 4 жыл бұрын
Glad it was helpful!
@joselitoreyes7187
@joselitoreyes7187 2 жыл бұрын
How do I input: films that start with the letters S and T? Thank you for your help.
@PremKumar-er8fv
@PremKumar-er8fv 2 жыл бұрын
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-nn1qk
@saidsaid-nn1qk 4 жыл бұрын
Thank you teacher !
@Codemycom
@Codemycom 4 жыл бұрын
You're welcome!
@shubhamanbhule6123
@shubhamanbhule6123 3 жыл бұрын
I did'nt understand 31:21 part of how to import data and save file can u please explain it.
@Codemycom
@Codemycom 3 жыл бұрын
Didn't I show how to do it in the video?
@conradlewis5689
@conradlewis5689 5 жыл бұрын
Very well done! Keep up the good work!
@Codemycom
@Codemycom 5 жыл бұрын
Thanks! Glad you enjoyed it!
@ToddsDiscGolf
@ToddsDiscGolf 2 жыл бұрын
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
@gabrielgomes6876
@gabrielgomes6876 3 жыл бұрын
Really enjoyed this course
@Codemycom
@Codemycom 3 жыл бұрын
Thanks!
@albinmiftari1832
@albinmiftari1832 2 жыл бұрын
Postgres 10 in the video, in 14 you need to write "INSERT INTO public.customers" so skip the "" at 34:04
@JBGecko13yt
@JBGecko13yt 5 жыл бұрын
Great video! I will be sharing it and adding it to one of my play lists
@Codemycom
@Codemycom 5 жыл бұрын
Glad you liked it!
@AmandeepSingh-ip4oo
@AmandeepSingh-ip4oo 7 ай бұрын
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.
@Codemycom
@Codemycom 7 ай бұрын
that's fine
@Orokusaki1986
@Orokusaki1986 2 жыл бұрын
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... =-\
@Orokusaki1986
@Orokusaki1986 2 жыл бұрын
I figured it out via stack overflow - use the next icon over, the 3 disk shaped "Save data changes" button, or F6
@CR-lz5yx
@CR-lz5yx 3 жыл бұрын
Awesome👍
@Codemycom
@Codemycom 3 жыл бұрын
thanks!
@sandeepkumar-bh4de
@sandeepkumar-bh4de 3 жыл бұрын
If sql coding dialog box move in other place then how i set it on its default place?
@thejesudayan7786
@thejesudayan7786 2 жыл бұрын
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
@ArtLoverDaiana
@ArtLoverDaiana 4 жыл бұрын
PGadmin overview 18:32
@omofolawaalimi-adeniran631
@omofolawaalimi-adeniran631 2 жыл бұрын
Thanks John, so enlightening!
@Codemycom
@Codemycom 2 жыл бұрын
welcome!
@frikbrits6335
@frikbrits6335 3 жыл бұрын
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г
@ЛинаКулагина-и1г 3 жыл бұрын
Спасибо! Очень хорошо рассказано, понятно что и как делать !!!!
@ilyalain5516
@ilyalain5516 4 жыл бұрын
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 :(
@Codemycom
@Codemycom 4 жыл бұрын
Weird...what did you do differently from my videos?
@ilyalain5516
@ilyalain5516 4 жыл бұрын
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-tq1fz
@Shubham-tq1fz 4 жыл бұрын
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
@arunbeckham8384
@arunbeckham8384 4 жыл бұрын
did you got rectified bro?
@GodofChookie
@GodofChookie 4 жыл бұрын
same here
@Mahesh-gq7fm
@Mahesh-gq7fm 4 жыл бұрын
Tnk u. superb. easy to understand
@learningchannel88
@learningchannel88 5 жыл бұрын
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?
@Codemycom
@Codemycom 5 жыл бұрын
In the video, I talk about using one of three different connectors (if one doesn't work). Did you try all three?
@greengrer
@greengrer 3 жыл бұрын
Well explained
@Codemycom
@Codemycom 3 жыл бұрын
Thanks!
@JosephOjebode
@JosephOjebode Жыл бұрын
Can you PLEASE do a video on how to create a cluster with a different user different from default user (POSTGRES)
@aninehartog3950
@aninehartog3950 3 жыл бұрын
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?
@mishalbisharat4065
@mishalbisharat4065 3 жыл бұрын
Hi John I cannot add my data in the colums ?
@aykutsirma4260
@aykutsirma4260 4 жыл бұрын
really nice tutorial and clean explanation
@Codemycom
@Codemycom 4 жыл бұрын
Glad you liked it!
@aykutsirma4260
@aykutsirma4260 4 жыл бұрын
@@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.
@sylveriakimbi2467
@sylveriakimbi2467 4 жыл бұрын
This is a great tutorial.
@Codemycom
@Codemycom 4 жыл бұрын
Thanks!
@johanapolinarioveliz6754
@johanapolinarioveliz6754 3 жыл бұрын
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?
@hanadraskovic6839
@hanadraskovic6839 3 жыл бұрын
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
@vishnusingh4118
@vishnusingh4118 3 жыл бұрын
New table created at 24:33. Finally! Pheww!
@Codemycom
@Codemycom 3 жыл бұрын
lol
@fadligababe3627
@fadligababe3627 4 жыл бұрын
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
@Codemycom
@Codemycom 4 жыл бұрын
what file do you mean?
@fadligababe3627
@fadligababe3627 4 жыл бұрын
@@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
@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
@Codemycom Жыл бұрын
Not sure what you mean...but delete everything, watch the video again, follow along exactly.
@reggiessmith7707
@reggiessmith7707 3 жыл бұрын
Thanks for your help! What about Mac users?
@kgaurav35
@kgaurav35 3 жыл бұрын
maybe watch Postico tutorials :))
@testeteste296
@testeteste296 5 жыл бұрын
Thank you very much. Couldn't find it anywhere else.
@Codemycom
@Codemycom 5 жыл бұрын
Glad you liked it!
@techgix
@techgix 2 жыл бұрын
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
@setarehzare37 Жыл бұрын
thank you!
@Codemycom
@Codemycom Жыл бұрын
Welcome!
@MeeMawBarb
@MeeMawBarb 2 жыл бұрын
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
@Brian-xb7qv Жыл бұрын
look up joins
@MeeMawBarb
@MeeMawBarb Жыл бұрын
@@Brian-xb7qv can you give me a LINK to the video please? Thanks!!
@bolajigiwa2117
@bolajigiwa2117 3 жыл бұрын
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?
@Codemycom
@Codemycom 3 жыл бұрын
What do you mean, just save it. Click the file>save button on the text editor.
@ankushtagore4299
@ankushtagore4299 Жыл бұрын
Walterwhite is teaching Postgre, I can't refuse to watch in one go
@Codemycom
@Codemycom Жыл бұрын
Ha!
@shawnbeans7389
@shawnbeans7389 4 жыл бұрын
can i use this for django?
@manishkhatrichhetri3150
@manishkhatrichhetri3150 2 жыл бұрын
I don't see any coupon code. Can you provide coupon code so that I can buy from Udemy?
@Codemycom
@Codemycom 2 жыл бұрын
JOHN_ELDER25
@bhavinmoriya9216
@bhavinmoriya9216 3 жыл бұрын
Hi how could I increase the size of the font of the database tree pannel in pgadmin4?
@Codemycom
@Codemycom 3 жыл бұрын
no clue
@tyrrelldavis9919
@tyrrelldavis9919 5 жыл бұрын
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
@pdx96
@pdx96 4 жыл бұрын
What's the error message? Is 1 already taken? Primary keys cannot be used by another row.
@caseyco21707
@caseyco21707 3 жыл бұрын
Great informative Video, really appreciate your work!
@Codemycom
@Codemycom 3 жыл бұрын
Thanks!
@najibadam
@najibadam 5 жыл бұрын
Great work! How can i find the continue of this lesson in udemy? thanks
@Codemycom
@Codemycom 5 жыл бұрын
You can find it here at discount today: bit.ly/2MIpwJh
@joonaschuk2016
@joonaschuk2016 4 жыл бұрын
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.
@Codemycom
@Codemycom 4 жыл бұрын
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.
@joonaschuk2016
@joonaschuk2016 4 жыл бұрын
@@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.
@aldystudent
@aldystudent 4 жыл бұрын
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?
@aldystudent
@aldystudent 4 жыл бұрын
After spending another hour to find the fix, I am happy to inform you that I managed to install it without any error.
@shaharharel6088
@shaharharel6088 2 жыл бұрын
thank you for the video. very helpful! cheers from Israel ✌
@Codemycom
@Codemycom 2 жыл бұрын
Glad you enjoyed it!
@akanshajain2938
@akanshajain2938 4 жыл бұрын
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
@Codemycom
@Codemycom 4 жыл бұрын
Sure, but without knowing your situation, I couldn't guess.
@akanshajain2938
@akanshajain2938 4 жыл бұрын
@@Codemycom Can you let me know a mail id on which I can contact and elaborate my issue?
@harshithareddy4911
@harshithareddy4911 4 жыл бұрын
Hi there , I couldn’t find PostgreSQL under server though I installed both . Can someone help me with this?
@Codemycom
@Codemycom 4 жыл бұрын
Try reinstalling it. Watch the video again to see what you missed
@leenathorat1624
@leenathorat1624 4 жыл бұрын
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...
@Codemycom
@Codemycom 4 жыл бұрын
Ha
@arturmelosantiagoferreira157
@arturmelosantiagoferreira157 5 жыл бұрын
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)
@tyrrelldavis9919
@tyrrelldavis9919 5 жыл бұрын
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
@shanildajones6208
@shanildajones6208 2 жыл бұрын
How come you didn’t use the postgresql shell
@Codemycom
@Codemycom 2 жыл бұрын
why would I?
@khalidelmoussaoui2175
@khalidelmoussaoui2175 3 жыл бұрын
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
@Codemycom
@Codemycom 3 жыл бұрын
No sorry
@balajinatarajan9125
@balajinatarajan9125 2 жыл бұрын
how to import sharepoint data
@no_deploy_friday
@no_deploy_friday 4 жыл бұрын
Thank you very much
@Codemycom
@Codemycom 4 жыл бұрын
You are welcome
@jameshagood2373
@jameshagood2373 5 жыл бұрын
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
@Codemycom
@Codemycom 5 жыл бұрын
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.
@jameshagood2373
@jameshagood2373 5 жыл бұрын
@@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
@tosh369
@tosh369 2 жыл бұрын
Skip the PostgreSQL install and the explanation of what a database is by going to 18:28
@arianitonline8748
@arianitonline8748 2 жыл бұрын
elephant vs dolphin?! tough choice
@maulikpatel3975
@maulikpatel3975 3 жыл бұрын
My personnel favorite - "FLAT_EARTH_GUY" !!
@Codemycom
@Codemycom 3 жыл бұрын
Ha
@Stiefel1990
@Stiefel1990 4 жыл бұрын
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?
@undercrackers56
@undercrackers56 4 жыл бұрын
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.
@Stiefel1990
@Stiefel1990 4 жыл бұрын
@@undercrackers56 Many thanks for your detailed answer. Can you give me a few technical terms I should deal with?
@mostafatagmouti338
@mostafatagmouti338 4 жыл бұрын
great work perfect tutorial thank you.
@Codemycom
@Codemycom 4 жыл бұрын
Glad you found it useful!
@DamnBoii123
@DamnBoii123 4 жыл бұрын
All of his tutorials are great
@Codemycom
@Codemycom 4 жыл бұрын
@@DamnBoii123 Thanks!
@ratmirsusanin5496
@ratmirsusanin5496 5 жыл бұрын
Thanks!
@Codemycom
@Codemycom 5 жыл бұрын
Enjoy!
@zachwhite8054
@zachwhite8054 4 жыл бұрын
Thank you sir.
@Codemycom
@Codemycom 4 жыл бұрын
You're very welcome!
@joemakulila9758
@joemakulila9758 4 жыл бұрын
i have intalled postgresql, im now trying to install Dspace
@Codemycom
@Codemycom 4 жыл бұрын
ok
@johncortenbach3574
@johncortenbach3574 3 жыл бұрын
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
@laychivoanvimol5871
@laychivoanvimol5871 4 жыл бұрын
when i click save,It doesnt automatically assign number 1 to id.why?
@Codemycom
@Codemycom 4 жыл бұрын
Cuz you did something wrong with your code, I assume...
@1sam2fisher
@1sam2fisher 4 жыл бұрын
Look for "postgresql auto increment" on google, I assume that will be enough.
@edwinthompson7402
@edwinthompson7402 4 жыл бұрын
great informative video, much appreciated
@Codemycom
@Codemycom 4 жыл бұрын
Glad You liked it!
@WaldoTheWombat
@WaldoTheWombat 4 жыл бұрын
You Rock!
@Codemycom
@Codemycom 4 жыл бұрын
Thanks!
@vaishnavihurde8145
@vaishnavihurde8145 5 жыл бұрын
what is key difference between postgreSQ and MYSQL
@siweiwu65
@siweiwu65 5 жыл бұрын
MYSQL is way better than PostgreSQL, trust me that is true. PostgreSQL query language is so stupid.
@paulonteri
@paulonteri 5 жыл бұрын
@@siweiwu65 PostgreSQL is very efficient and even used by big companies such as Instagram
@soccerfp
@soccerfp 4 жыл бұрын
@@siweiwu65 dumbest comment of the year goes to...
@omkars764
@omkars764 4 жыл бұрын
it wont let me save after inserting into table
@Codemycom
@Codemycom 4 жыл бұрын
Did you google the error you're getting?
@swarupsarangi734
@swarupsarangi734 4 жыл бұрын
click on "Save Data Changes(F6)" icon on the right side of "Save File" icon .
@cloudsystem3740
@cloudsystem3740 Жыл бұрын
thanks
@Codemycom
@Codemycom Жыл бұрын
Welcome!
@Jaxxy35
@Jaxxy35 4 жыл бұрын
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
@EhsanRavana
@EhsanRavana 2 жыл бұрын
perfect
@Codemycom
@Codemycom 2 жыл бұрын
Thanks!
@vaggelismanousakis6147
@vaggelismanousakis6147 4 жыл бұрын
Thinking of buying a course for intermediate level as I have Data Bases(SQL) class in this semester. Thanks for the video!
@Codemycom
@Codemycom 4 жыл бұрын
Cool!
@ShevchenkoKirill
@ShevchenkoKirill Жыл бұрын
O god, it's Heisenberg!
@Codemycom
@Codemycom Жыл бұрын
Ha!
@Sure_Math_Center
@Sure_Math_Center Жыл бұрын
Cool
@Codemycom
@Codemycom Жыл бұрын
THanks
@dilzodbekabdusattorov4204
@dilzodbekabdusattorov4204 3 жыл бұрын
best
@Codemycom
@Codemycom 3 жыл бұрын
Thanks!
@VegetaZA
@VegetaZA 4 жыл бұрын
Thanks bro!
@Codemycom
@Codemycom 4 жыл бұрын
Sure thing!
@eskailash
@eskailash 4 жыл бұрын
1. how to open pgAdmin is told 2. how to close/shut down pgAdmin is not explain................. ????
@Codemycom
@Codemycom 4 жыл бұрын
isn't it in the web browser? Close the tab dude
@shafiaziz1483
@shafiaziz1483 3 жыл бұрын
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
@Codemycom
@Codemycom 3 жыл бұрын
I think you're mistaken
APIs for Beginners - How to use an API (Full Course / Tutorial)
2:19:33
freeCodeCamp.org
Рет қаралды 4,4 МЛН
PostgreSQL CRASH COURSE - Learn PostgreSQL in 2024
50:26
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 15 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,2 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
PostgreSQL Indexing : How, why, and when.
31:21
PyCon AU
Рет қаралды 79 М.
pgAdmin Tutorial - How to Use pgAdmin
15:28
Database Star
Рет қаралды 238 М.
Database Indexing Explained (with PostgreSQL)
18:19
Hussein Nasser
Рет қаралды 322 М.
PostgreSQL vs MySQL
6:33
IBM Technology
Рет қаралды 358 М.
Introduction to PostgreSQL Tutorial - Part 1
17:13
Database Star
Рет қаралды 53 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 219 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,6 МЛН
PostgreSQL Tutorial Full Course 2022
3:42:11
Derek Banas
Рет қаралды 309 М.
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 15 МЛН