pgAdmin Tutorial - How to Use pgAdmin

Подписаться 53 тыс.

Просмотров 183 тыс.

50% 1

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
pgAdmin is a popular SQL editor for Postgres. It comes installed with Postgres and works on both Windows and Mac.
Learn how to get started with pgAdmin and how to use many of its features in this video.
Timestamps:
00:00 Introduction and download
02:06 Open pgAdmin and enter master password
02:40 Main window
03:28 Create new connection (server)
04:58 Toolbar buttons
05:37 Query tool
09:01 Save and open queries
09:34 Edit button
11:00 Explain plan
12:46 Search for objects
13:22 Other features
14:20 Preferences

Наука

Опубликовано:

2 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 151

@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!

@tomgoral313 6 месяцев назад

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

@DatabaseStar 6 месяцев назад

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!

@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!

@adewunmiroland8436 7 месяцев назад

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

@DatabaseStar 7 месяцев назад

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

@Dean-LongSol 21 день назад

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

@DatabaseStar 19 дней назад

You're welcome!

@bobtabor4133 11 месяцев назад

Very crisp, well presented. Thank you!

@DatabaseStar 11 месяцев назад

You're very welcome!

@ZergD 3 месяца назад

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

@DatabaseStar 3 месяца назад

You're welcome!

@ericijakaa1093 Год назад

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

@DatabaseStar Год назад

No problem, glad it helped!

@nanaphiona5145 Год назад

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

@DatabaseStar Год назад

Thanks!

@melovated Год назад

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

@DatabaseStar Год назад

Thanks! Glad it was helpful!

@kylefrizol2433 Год назад

This is brilliant mate, thank you!

@DatabaseStar Год назад

Glad it helped!

@korrupted80 2 месяца назад

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

@DatabaseStar 2 месяца назад

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

@sayalitandel5009 4 месяца назад

Simple and concise, perfect!

@DatabaseStar 4 месяца назад

Glad it was helpful!

@user-kv7nb5eq3e Год назад

Thank you for being clear and concise.

@DatabaseStar Год назад

You're welcome!

@moslemuddin3104 Год назад

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

@DatabaseStar Год назад

Thanks!

@rebeccamey4133 9 месяцев назад

Exactly what I was looking for, thank you.

@DatabaseStar 9 месяцев назад

Glad I could help!

@TheMaxKids Год назад

Best video on pgAdmin. Thank you!

@DatabaseStar Год назад

Glad you liked it!

@natalieblinnikova3971 Год назад

thanks, the way you talk is really peacefull

@DatabaseStar Год назад

Thanks!

@dingorvr Год назад

Thank you so much for the explanation!

@DatabaseStar Год назад

You're very welcome!

@Cos_Wayne Год назад

To the point and clear. Yessir!

@DatabaseStar Год назад

Thanks!

@florencearong4216 9 месяцев назад

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

@DatabaseStar 9 месяцев назад

Glad it helped!

@biswajit-k Год назад

Great Tutorial! Thanks!

@DatabaseStar Год назад

You're welcome!

@htavli Год назад

Thank you, this was very helpful!

@DatabaseStar Год назад

You’re welcome!

@Ganasankar8 11 месяцев назад

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

@DatabaseStar 11 месяцев назад

Glad it helped!

@nicholassmith6412 Год назад

Very helpful intro, thanks

@DatabaseStar Год назад

Glad it was helpful!

@LeviElekes 3 месяца назад

thanks for your video

@DatabaseStar 3 месяца назад

You're welcome

@didiergillet157 Год назад

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

@DatabaseStar Год назад

Glad it helped!

@frankflej8175 Год назад

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

@DatabaseStar Год назад

Glad it was helpful!

@benjaminkhoury304 Год назад

Thanks for the video, helped a lot!

@DatabaseStar Год назад

Glad it was helpful!

@vitaliyshastun4162 Год назад

Top-notch explanation, thanks! 🌟

@DatabaseStar Год назад

Glad it was helpful!

@bytecode5834 7 месяцев назад

Very nice video. Thanks a lot for your help!

@DatabaseStar 7 месяцев назад

Glad it helped!

@ThroinOakenshield Год назад

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

@DatabaseStar Год назад

You’re welcome!

@nakul-- Год назад

very helpful! Thanks.

@DatabaseStar Год назад

Glad it was helpful!

@kateelfridaodeh 19 дней назад

Thanks for this video

@DatabaseStar 16 дней назад

You're welcome

@talharafique8913 Год назад

thanks for this. really appriciated

@DatabaseStar Год назад

No worries!

@lennyedwards62 Год назад

Great vid. Subscribed

@DatabaseStar Год назад

Awesome, thank you!

@user-ku1pp3ej9m 4 месяца назад

Thank you so much👍👍👍

@DatabaseStar 4 месяца назад

You’re welcome!

@phasematerialsresearch9319 8 месяцев назад

Very concise and helpful!

@DatabaseStar 8 месяцев назад

Glad it was helpful!

@ScottShaulis 9 месяцев назад

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 9 месяцев назад

Thanks! Hope you get that timeout issue solved.

@zk__27 7 месяцев назад

Thank you!

@DatabaseStar 7 месяцев назад

You're welcome!

@gurvannicolas2220 Год назад

Thanks for this , its very usefull

@DatabaseStar Год назад

Glad it was helpful!

@codyfsw Год назад

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

@DatabaseStar Год назад

Thanks a lot!

@MudassirKhan-sx9jy 10 месяцев назад

thank you. it was really helpfull.

@DatabaseStar 10 месяцев назад

Glad it helped!

@Utp77 4 месяца назад

very nice

@DatabaseStar 4 месяца назад

Thanks!

@kehindefagbohungbe 5 месяцев назад

Thank you

@DatabaseStar 5 месяцев назад

You're welcome!

@sambarajkanaveni7312 Год назад

It helps boss👍

@DatabaseStar Год назад

Good to hear!

@animal9470 3 месяца назад

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 3 месяца назад

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.

@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.

@prakashyemineni5199 Год назад

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.

@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.

@BijouBakson Год назад

The volume could be louder. Thank you for the effort

@DatabaseStar Год назад

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

@user-ur5to9hj5s Год назад

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.

@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?

@kennethchibuzo7626 9 месяцев назад

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

@DatabaseStar 9 месяцев назад

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

@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?

@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.

@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.

@Just-An-Average-Guy 11 месяцев назад

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 11 месяцев назад

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

@anushkasaxena6742 4 месяца назад

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

@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.

@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.

@Bruno-tw8rw 2 месяца назад

Hey, pgadmin has a web version?

@DatabaseStar 2 месяца назад

I don’t know if they do

@ivanignacio2353 8 месяцев назад

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

@DatabaseStar 8 месяцев назад

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

@bachinaganesh1891 8 месяцев назад

how to delete the adminstartor user in pgadmin

@DatabaseStar 8 месяцев назад

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.

@nobeliccodepro5418 6 месяцев назад

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 5 месяцев назад

Do you have Postgres running on your computer?