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.
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
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
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?
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... =-\
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?
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...
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
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 ??
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.
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?
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.
@@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.
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
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?
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?
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
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
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 :’)
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 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.
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?
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
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
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.
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!
To skip the install and theory, go straight to: 18:30
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!
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!
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!
This is a good introductory tutorial for PostgresSQL and the tools which enforce it. Good job here Codemy.
Glad you enjoyed it!
How can I see the datatype length like (VARCHAR(30)) along with attribute name in table.......
Skip to 18:33 if you already have everything installed and already know what a database is...
Thank you sir. Great video.
You're welcome!
Very well done! Keep up the good work!
Thanks! Glad you enjoyed it!
Great video! I will be sharing it and adding it to one of my play lists
Glad you liked it!
Informative and easy to understand. Thank you!
Glad it was helpful!
thanks a lot for quick and comprehensive tutorial.
Welcome!
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
Спасибо! Очень хорошо рассказано, понятно что и как делать !!!!
such a good and descriptive tutorial.. Love it!!
Thanks!
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
Thank you teacher !
You're welcome!
Perfect! All I needed!
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?
starts at 3:26
Interesting suggestion.
Someone give this (wo)man a Like!
thank you sir love from Nepal
Welcome!
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!
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
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?
Thanks John, so enlightening!
welcome!
Awesome👍
thanks!
Can you PLEASE do a video on how to create a cluster with a different user different from default user (POSTGRES)
Really enjoyed this course
Thanks!
Tnk u. superb. easy to understand
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
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
This is a great tutorial.
Thanks!
Thank you very much. Couldn't find it anywhere else.
Glad you liked it!
New table created at 24:33. Finally! Pheww!
lol
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
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 ??
Thanks
Welcome
Thinking of buying a course for intermediate level as I have Data Bases(SQL) class in this semester. Thanks for the video!
Cool!
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
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?
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.
Postgres 10 in the video, in 14 you need to write "INSERT INTO public.customers" so skip the "" at 34:04
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.
How do I input: films that start with the letters S and T? Thank you for your help.
PGadmin overview 18:32
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
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.
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)
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?
Well explained
Thanks!
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
elephant vs dolphin?! tough choice
Great informative Video, really appreciate your work!
Thanks!
Thanks!
Enjoy!
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!
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.
If sql coding dialog box move in other place then how i set it on its default place?
Hi John I cannot add my data in the colums ?
Walterwhite is teaching Postgre, I can't refuse to watch in one go
Ha!
I don't see any coupon code. Can you provide coupon code so that I can buy from Udemy?
JOHN_ELDER25
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
My personnel favorite - "FLAT_EARTH_GUY" !!
Ha
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
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!!
thank you for the video. very helpful! cheers from Israel ✌
Glad you enjoyed it!
great work perfect tutorial thank you.
Glad you found it useful!
All of his tutorials are great
@@DamnBoii123 Thanks!
perfect
Thanks!
You Rock!
Thanks!
Thank you very much
You are welcome
Thank you sir.
You're very welcome!
great informative video, much appreciated
Glad You liked it!
how to import sharepoint data
can i use this for django?
Thanks for your help! What about Mac users?
maybe watch Postico tutorials :))
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.
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.
best
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?
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?
How come you didn’t use the postgresql shell
why would I?
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
O god, it's Heisenberg!
Ha!
i have intalled postgresql, im now trying to install Dspace
ok
Cool
THanks
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
how could I increase the size of the font of the database tree pannel in pgadmin4?
no clue
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
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
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
Skip the PostgreSQL install and the explanation of what a database is by going to 18:28
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.
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?
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?
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 .
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...