pgAdmin Tutorial - How to Use pgAdmin

[@ryandwiky9025]

Looks for pgAdmin tutorial. Ends up with crystal clear explanation. Feels like I'm watching National Geographic.

[@DatabaseStar]

Heheh glad you like the video!

[@sdmagic]

"The admin sneaks through the bush in preparation to pounce on the unwary SQL statement..."

[@tomgoral313]

Thank you for this introduction to pgAdmin. It is very clear and concise !

[@DatabaseStar]

Glad it was helpful!

[@AnilKeshwani]

Really fantastic video. I got everything I needed to get set up with this new IDE - having been used to using T-SQL via Microsoft's SQL Workbench - in 7-8 minutes (on 2x speed) and it was extremely clear and to the point. Thanks very much

[@DatabaseStar]

Glad it was helpful!

[@firebug707]

Beautiful explanation, concise and to the point! Well done....

[@DatabaseStar]

Glad it was helpful!

[@korrupted80]

Thanks for covering this specifically for POSTGRESQL. I wish you would cover some more Database related material. Keep up the Good Work. 👏🏼

[@DatabaseStar]

Thanks! I have plenty of database material on this channel and I'll keep creating more.

[@michalroesler]

Yep. This is very useful video. It clearly describes the process of connecting to a database and explains all the dialog boxes.

[@DatabaseStar]

Thanks, I’m glad you like the video and found it useful

[@Animiribi]

Thank you very much for this well explained and quick tutorial! It is logical, helpful and gets to the point. By far the best pgAdmin tutorial I found.

[@DatabaseStar]

Thanks, I'm glad you liked it!

[@natalieblinnikova3971]

thanks, the way you talk is really peacefull

[@DatabaseStar]

Thanks!

[@nanaphiona5145]

Wow..what a tutorial!. All information has been provided in one video

[@DatabaseStar]

Thanks!

[@adewunmiroland8436]

I'm impressed. A detailed yet easy to understand tutorial.

[@DatabaseStar]

Thanks! Yeah I tried to make this a good tutorial for pgAdmin.

[@kylefrizol2433]

This is brilliant mate, thank you!

[@DatabaseStar]

Glad it helped!

[@TheMaxKids]

Best video on pgAdmin. Thank you!

[@DatabaseStar]

Glad you liked it!

[@Two-wheel-cult]

Awesome and to the point. Thanks for taking the time to record this video.

[@DatabaseStar]

You're welcome!

[@ZergD]

Simple, easy and to the point. Thank you very much!

[@DatabaseStar]

You're welcome!

[@sayalitandel5009]

Simple and concise, perfect!

[@DatabaseStar]

Glad it was helpful!

[@melovated]

Exactly what I needed and more! Thank you so much! 🤗

[@DatabaseStar]

Thanks! Glad it was helpful!

[@ib6548]

This is so wonderfully done. Thank you for sharing

[@DatabaseStar]

Glad you like it!

[@bobtabor4133]

Very crisp, well presented. Thank you!

[@DatabaseStar]

You're very welcome!

[@ericijakaa1093]

I was stuck, great work! Thank you so much!

[@DatabaseStar]

No problem, glad it helped!

[@didiergillet157]

Thanks. Clear, easy tu understand even for a french guy !!!

[@DatabaseStar]

Glad it helped!

[@moslemuddin3104]

great! clear presentation to understand step by step.Wishing you all the best.

[@DatabaseStar]

Thanks!

[@ScottChavez-s9w]

Thank you for being clear and concise.

[@DatabaseStar]

You're welcome!

[@dingorvr]

Thank you so much for the explanation!

[@DatabaseStar]

You're very welcome!

[@rebeccamey4133]

Exactly what I was looking for, thank you.

[@DatabaseStar]

Glad I could help!

[@florencearong4216]

Woohoo thank you so much, very clear and to the point.

[@DatabaseStar]

Glad it helped!

[@LeviElekes]

thanks for your video

[@DatabaseStar]

You're welcome

[@FracturedOctopus]

Great guide. Still can't even create the PGAdmin server on localhost due to a timeout error regardless of anything I do, but at leat I can understand my school lab now. Thank you!

[@DatabaseStar]

Thanks! Hope you get that timeout issue solved.

[@vinay3894]

Thanks for the explanation.

[@DatabaseStar]

You’re welcome!

[@frankflej8175]

Thank youu very much this is very good summary and well explained

[@DatabaseStar]

Glad it was helpful!

[@ganasankarmalla]

Thank you it's very helpful! keep up the good work.

[@DatabaseStar]

Glad it helped!

[@Cos_Wayne]

To the point and clear. Yessir!

[@DatabaseStar]

Thanks!

[@bytecode5834]

Very nice video. Thanks a lot for your help!

[@DatabaseStar]

Glad it helped!

[@htavli]

Thank you, this was very helpful!

[@DatabaseStar]

You’re welcome!

[@vitaliyshastun4162]

Top-notch explanation, thanks! 🌟

[@DatabaseStar]

Glad it was helpful!

[@nicholassmith6412]

Very helpful intro, thanks

[@DatabaseStar]

Glad it was helpful!

[@biswajit-k]

Great Tutorial! Thanks!

[@DatabaseStar]

You're welcome!

[@ThroinOakenshield]

よくわかりました。ありがとうございます。Thank you so much!

[@DatabaseStar]

You’re welcome!

[@talharafique8913]

thanks for this. really appriciated

[@DatabaseStar]

No worries!

[@nakul--]

very helpful! Thanks.

[@DatabaseStar]

Glad it was helpful!

[@user-ku1pp3ej9m]

Thank you so much👍👍👍

[@DatabaseStar]

You’re welcome!

[@gurvannicolas2220]

Thanks for this , its very usefull

[@DatabaseStar]

Glad it was helpful!

[@MudassirKhan-sx9jy]

thank you. it was really helpfull.

[@DatabaseStar]

Glad it helped!

[@kehindefagbohungbe]

Thank you

[@DatabaseStar]

You're welcome!

[@Utp77]

very nice

[@DatabaseStar]

Thanks!

[@zk__27]

Thank you!

[@DatabaseStar]

You're welcome!

[@phasematerialsresearch9319]

Very concise and helpful!

[@DatabaseStar]

Glad it was helpful!

[@sambarajkanaveni7312]

It helps boss👍

[@DatabaseStar]

Good to hear!

[@risdosagalavsjilong]

I would like to inquire about the possibility of using a custom hostname, such as 'laksamana-arya', for my PostgreSQL server. I understand that 'localhost' is the default, but I'm curious to know if there are any specific reasons why I cannot utilize a custom hostname.

[@DatabaseStar]

Not that I know of. I’ve never tried it but I don’t know if there would be any issues.

[@risdosagalavsjilong]

@@DatabaseStar oh sorry sir ,Thank you for taking the time to respond to me, I couldn't connect because I didn't expect to have to download PostgreSQL from EDB to run pgadmin4, no wonder I couldn't find PostgreSQL in service.msc, my friend said, it's like I already have a car with complete components such as a steering wheel and gas pedal but I don't have the engine to run it.

[@codyfsw]

Sub. Youre awesome man! keep up the good work!

[@DatabaseStar]

Thanks a lot!

[@BijouBakson]

The volume could be louder. Thank you for the effort

[@DatabaseStar]

Thanks! I'll keep that in mind for future videos.

[@RiddhishThakore]

In my pgadmin data type length is not shown ......How can I see the datatype length like (VARCHAR(30)) along with attribute name in table.......

[@DatabaseStar]

Oh I'm not sure, it usually displays by default for me.

[@prashlovessamosa]

Thank you

[@DatabaseStar]

You’re welcome

[@animal9470]

Can you not see data in your tables as a table and have the ability to click a cell and change the data like that? Does viewing and modifying data in the tables require you to write a sql query, or can you click and change it in some other view?

[@DatabaseStar]

I don't think you can do that in pgAdmin. You can in some other editors, but I don't know about pgAdmin. You'll have to write an SQL query.

[@ayoubid-ihia9419]

Hello, when I click on Save, after filling in the Host and password fields, I get this error message: `Unable to connect to server: connection to server at "localhost", port 5432 failed: FATAL: role "postgres" does not exist` What should I do? Thank you in advance.

[@DatabaseStar]

Oh that’s odd. Is Postgres running on your computer? If it is you may need to google for this error.

[@kennethchibuzo7626]

Please I need ur assistance urgently, my PostgreSQL refused to open after Mac update, I have uninstalled and reinstalled still not working

[@DatabaseStar]

Are you getting any errors when attempting to run Postgres? Did you install it using the package, homebrew, docker, or something else?

[@gerberstephane]

is there an advanced version, where we are shown how to use this fast and with shortcuts ?

[@DatabaseStar]

I don’t have a video on this, but that’s a great idea so I’ll create one in the future.

[@ucquanau2235]

Postgres Demo is the same instance different name right?

[@DatabaseStar]

Yeah that's right, it's another connection to the same instance.

[@mbrntgan]

why is it when I type inside the parenthesis the next letter will be typed outisde of it

[@DatabaseStar]

Oh I'm not sure, perhaps it's an issue with pgAdmin

[@freetimeexhibit5807]

i messed up the browser and tree control the ribbon for object in empty what the problem there?

[@DatabaseStar]

I’m not sure. Are you connected to a database? Do you see anything in the list?

[@esaietchagnonsi8179]

Thanks a lot for this one , but i have an issue. How can i get the password of maintenance database ?

[@DatabaseStar]

Glad you like it! What do you mean, get the password of maintenance database?

[@khurram6700]

What is the PostGre Server? you didn't mention anything about it.

[@DatabaseStar]

That is another name for the Postgres database that is running.

[@Nonsense116]

great video, audio is very quiet though

[@DatabaseStar]

Thanks! Yeah some of the older videos like this one had lower audio, and I've aimed to improve it in recent videos.

[@emre0316]

When I create a table on my Mac, pgadmin doesn’t show me my table on the left side can someone help me please

[@DatabaseStar]

Could you click the refresh button (or right click on the database and select Refresh)? Does that work?

[@emre0316]

@@DatabaseStar yes when I refresh nothing happens. I really don’t understand what the problem is.

[@prakash36g]

Is it possible to connect with any other databases like oracle or mysql with pgAdmin ?

[@DatabaseStar]

I don't think so, as it's designed for Postgres and comes with the Postgres database. I couldn't see anything about it with a quick Google search, but it doesn't mean it's not possible.

[@Just-An-Average-Guy]

what should i do if it doesnt ask me to set up a master password when i open it?? how can i set it up????

[@DatabaseStar]

Oh I'm not sure, I've always been asked to provide a master password when I install it.

[@anushkasaxena6742]

​@@DatabaseStarSame problem happen with me too. It doesn't ask for a password

[@nobeliccodepro5418]

Unable to connect to server: connection to server at "localhost" (:1), port 5432 failed: Connection refused (0x00002740/10061) Is the Error 😞😢 server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed Connection refused (0x00002740/10061) Is the server running on that host and accepting TCP/IP connections?

[@DatabaseStar]

Do you have Postgres running on your computer?

[@taymookrumpli3991]

i do not have servers on my pc then how should i install this?

[@DatabaseStar]

Ah then I think you’ll need to install Postgres first. You can do this from the Postgres website.

[@ivanignacio2353]

it didnt ask me to set a master password i dont know why

[@DatabaseStar]

Oh that's strange, I think another commenter said the same thing too.

[@Bruno-tw8rw]

Hey, pgadmin has a web version?

[@DatabaseStar]

I don’t know if they do

[@cynthiaabims9010]

Mine didn’t request for password and I can’t set up 😊

[@DatabaseStar]

Oh that’s odd. Might be something you’ll have to Google

[@vikalpbhatt4382]

Pg admin not asking master password how to fix this?

[@DatabaseStar]

Oh I’m not sure. Maybe there’s a config setting that can be changed.

[@bachinaganesh1891]

how to delete the adminstartor user in pgadmin

[@DatabaseStar]

I’m not sure how to do that. Why would you want to delete it though?

[@JM-fr9bc]

Is there a part 2?

[@DatabaseStar]

Not specifically a part 2 video, but I have plans to make a more advanced pgAdmin video soon.

[@zeyadelsobky]

How to use Scratch Pad?

[@DatabaseStar]

I haven’t used it very much but I think it’s helpful as a temporary place for storing text

[@babumosai549]

Its showing unable to connect?

[@DatabaseStar]

Do you have Postgres installed? Do you know if it is running?

[@babumosai549]

@@DatabaseStar thank u, finally done.🙏

[@ramonvalles4375]

what is the password?

[@DatabaseStar]

It's the password you set when you created your Postgres database, which is not handled by pgAdmin.

[@Sam-81810]

ok

[@DatabaseStar]

Thanks!

[@benjaminkhoury304]

Thanks for the video, helped a lot!

[@DatabaseStar]

Glad it was helpful!

[@kateelfridaodeh]

Thanks for this video

[@DatabaseStar]

You're welcome