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.
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.
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
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
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?
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.
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... =-\
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
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 :(
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 :’)
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?
@@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.
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?
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?
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 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)
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?
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 ??
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.
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 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.
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!!
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
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?
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
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
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.
@@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
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
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...
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?
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.
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
Finally Walter White comes to teaching SQL
Almost sounds like Bryan too 🤒
Only for this string it was worth to scroll the comments!
XD
skip the install part if you already have the setup in place: 12:12
Thank you, Daiana!
wish I saw your comment at the beginning . Seeing your comment after the vdo completion XD
Thank you!!
Awesome! It's so difficult to find tutorials that don't spend most of the time explaining the product benefits!
Glad you liked it!
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.
glad you liked it!
To skip the install and theory, go straight to: 18:30
This is a good introductory tutorial for PostgresSQL and the tools which enforce it. Good job here Codemy.
Glad you enjoyed it!
Skip to 18:33 if you already have everything installed and already know what a database is...
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 🤗🤗🤗
Glad you enjoyed it!
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.
Glad you found it useful!
thanks a lot for quick and comprehensive tutorial.
Welcome!
Thank you sir. Great video.
You're welcome!
Very well done! Keep up the good work!
Thanks! Glad you enjoyed it!
such a good and descriptive tutorial.. Love it!!
Thanks!
Informative and easy to understand. Thank you!
Glad it was helpful!
How can I see the datatype length like (VARCHAR(30)) along with attribute name in table.......
Great video! I will be sharing it and adding it to one of my play lists
Glad you liked it!
Perfect! All I needed!
Thank you teacher !
You're welcome!
Awesome👍
thanks!
if you are not able to save the input data in table by clicking the icon try pressing F6 32:29
thanks. you save me
Thank you!
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
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
Thanks John, so enlightening!
welcome!
I did'nt understand 31:21 part of how to import data and save file can u please explain it.
Didn't I show how to do it in the video?
Really enjoyed this course
Thanks!
Спасибо! Очень хорошо рассказано, понятно что и как делать !!!!
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?
Tnk u. superb. easy to understand
Postgres 10 in the video, in 14 you need to write "INSERT INTO public.customers" so skip the "" at 34:04
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.
that's fine
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... =-\
I figured it out via stack overflow - use the next icon over, the 3 disk shaped "Save data changes" button, or F6
How do I input: films that start with the letters S and T? Thank you for your help.
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
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
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 :(
Weird...what did you do differently from my videos?
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 :’)
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
did you got rectified bro?
same here
thank you sir love from Nepal
Welcome!
Well explained
Thanks!
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?
really nice tutorial and clean explanation
Glad you liked it!
@@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.
This is a great tutorial.
Thanks!
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?
Not sure what you mean...but delete everything, watch the video again, follow along exactly.
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?
Thank you very much. Couldn't find it anywhere else.
Glad you liked it!
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
what file do you mean?
@@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)
If sql coding dialog box move in other place then how i set it on its default place?
starts at 3:26
Interesting suggestion.
Someone give this (wo)man a Like!
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?
In the video, I talk about using one of three different connectors (if one doesn't work). Did you try all three?
Great informative Video, really appreciate your work!
Thanks!
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 ??
Can you PLEASE do a video on how to create a cluster with a different user different from default user (POSTGRES)
Hi John I cannot add my data in the colums ?
I don't see any coupon code. Can you provide coupon code so that I can buy from Udemy?
JOHN_ELDER25
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.
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?
What do you mean, just save it. Click the file>save button on the text editor.
thank you!
Welcome!
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.
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.
@@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.
can i use this for django?
New table created at 24:33. Finally! Pheww!
lol
Thanks for your help! What about Mac users?
maybe watch Postico tutorials :))
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!!
look up joins
@@Brian-xb7qv can you give me a LINK to the video please? Thanks!!
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
Sure, but without knowing your situation, I couldn't guess.
@@Codemycom
Can you let me know a mail id on which I can contact and elaborate my issue?
Hi
how could I increase the size of the font of the database tree pannel in pgadmin4?
no clue
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?
After spending another hour to find the fix, I am happy to inform you that I managed to install it without any error.
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
What's the error message? Is 1 already taken? Primary keys cannot be used by another row.
PGadmin overview 18:32
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
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.
@@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
Great work! How can i find the continue of this lesson in udemy?
thanks
You can find it here at discount today: bit.ly/2MIpwJh
how to import sharepoint data
Skip the PostgreSQL install and the explanation of what a database is by going to 18:28
Walterwhite is teaching Postgre, I can't refuse to watch in one go
Ha!
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
No sorry
Hi there , I couldn’t find PostgreSQL under server though I installed both . Can someone help me with this?
Try reinstalling it. Watch the video again to see what you missed
How come you didn’t use the postgresql shell
why would I?
Thank you very much
You are welcome
Thanks!
Enjoy!
great work perfect tutorial thank you.
Glad you found it useful!
All of his tutorials are great
@@DamnBoii123 Thanks!
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
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)
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
Thank you sir.
You're very welcome!
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...
Ha
i have intalled postgresql, im now trying to install Dspace
ok
perfect
Thanks!
when i click save,It doesnt automatically assign number 1 to id.why?
Cuz you did something wrong with your code, I assume...
Look for "postgresql auto increment" on google, I assume that will be enough.
You Rock!
Thanks!
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?
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.
@@undercrackers56 Many thanks for your detailed answer. Can you give me a few technical terms I should deal with?
Thinking of buying a course for intermediate level as I have Data Bases(SQL) class in this semester. Thanks for the video!
Cool!
what is key difference between postgreSQ and MYSQL
MYSQL is way better than PostgreSQL, trust me that is true. PostgreSQL query language is so stupid.
@@siweiwu65 PostgreSQL is very efficient and even used by big companies such as Instagram
@@siweiwu65 dumbest comment of the year goes to...
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
thanks
Welcome!
it wont let me save after inserting into table
Did you google the error you're getting?
click on "Save Data Changes(F6)" icon on the right side of "Save File" icon .
elephant vs dolphin?! tough choice
thank you for the video. very helpful! cheers from Israel ✌
Glad you enjoyed it!
great informative video, much appreciated
Glad You liked it!
My personnel favorite - "FLAT_EARTH_GUY" !!
Ha
Cool
THanks
1. how to open pgAdmin is told
2. how to close/shut down pgAdmin is not explain................. ????
isn't it in the web browser? Close the tab dude
best
Thanks!
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
I think you're mistaken
Add Column BEFORE/AFTER another column is not possible in Postgres!!!!!
huh?
O god, it's Heisenberg!
Ha!