pgAdmin: Entity-Relationship Diagram (ERD) Tool Demo - [PostgreSQL Tutorial]

[@ПетроКобзар]

The most important on 6:15
PS it would be great to begin this video from that point!

[@ven7782]

Thanks mate. This is exactly what I needed.

[@fatoumatabintabarry4214]

Thank you so much

[@pushkardey]

Thanks, short and sweet... and direct to the point.

[@donaldjeffersonthabah2451]

What about 1-1 relationship?

[@christinabaker7021]

Exactly. Why isn't there a 1:1 relationship line?

[@dana1virtual]

That was extremely helpful for a Postgres noob! TYVM. terrific video!

[@serunisupport9137]

When I click "Download image", then save it, why the PNG don't show some of the lines on the left and middle area?

[@eronlloyd]

How did I miss this feature? Thanks for the video!

[@bizimsiti]

how can i add one to one realationship ?

[@ezequiasrocha3037]

I already have the database. It is possible to load schema to this canvas?

[@adityatoshniwal8842]

Yes, as shown in the video, you can right click on the DB and click Generate ERD. From 06:15

[@JimRohn-u8c]

Is there a way to add a “1 to 1” relationship?

[@adityatoshniwal5091]

1 to 1 would behave same a 1 to M. 1 to 1 is just a representation.

[@xybersurfer]

usually you should try to avoid 1 to 1 relationships, and make it into 1 table

[@mr.random8447]

@@xybersurfer if modeling super type and subtype, need 1:1

[@xybersurfer]

@@mr.random8447 agreed. there are some ugly alternatives for inheritance:
- storing every field in a name and value record ("inner-platform effect")
- i also read that some databases have proprietary support for inheritance (potential "vendor lock-in")
proprietary support for inheritance, doesn't sound completely bad

[@lyssaflynn7598]

Is there a way for pgAdmin to generate the visualization of already existing tables? While you draw the tables and draw the connections, the pgAdmin generated queries to create the tables in database, but is it possible to do it opposite way? I have database with tables that are created by python and I want them to be displayed graphically like you draw them. Thanks in advance!

[@lyssaflynn7598]

Nevermind, I've actually figured it out myself -> Right mouse click on database and "ERD For Database" :)

[@william3588]

Which version is this?

[@manee427]

hi Thanks .what about one to one relationship? i cant see it in the menu.

[@sevvalacet5476]

of siz hitlilerde olmasanız nabıcam acaba.THANK YOU

[@pradeepnooney3056]

Any idea how to do setup for one to one relation (as i can see only one to many and many to many) ..By the way thanks for the video

[@klinz1404]

There is a one to many button (Displayed as "1M") on the top of the screen.

[@christinabaker7021]

@@klinz1404 what about 1:1?

[@mohammad_bilal951]

how to generate ERD from an existing DB

[@alessandram.3289]

This really helped me, thank you!

[@rickhehe]

Thanks mate. Very nice demo.

[@gottastoppo]

It's not there. How do i find it even?
Or is it like only for 64bit version? Too bad.

[@fal8202]

Thanks for the presentation, keep up the good work!

[@chatanick]

how to make pgadmin show table name on upper bar(table bar)?

[@samailas.malgwi8900]

That was great, I was really helped. Thank you.

[@SailingCatamaranElement]

Nice Video - Keep up the great work! Have you found a nice method to migrate a legacy Access database as a new Postrges database including its relationships?

[@edarumeysagurgen657]

yarım saattir aradığım şey ya gerçekten canım hintliler:)

[@muhammetoguzhanaydogdu8448]

Engin hoca bizi nerelere getirdi :D

[@bojjabheemaraju387]

Very nice video. Thank you.

[@virginiawalter1761]

super video! Thank you for making it!

[@feratefil7436]

I benefided from your video. Thank you very much

[@МатвейМанько-ь6ч]

Thanks from Russia!

[@zizaart1199]

Thank you!

[@EDBPostgres]

You're welcome!

[@izaliyeva338]

thank you very much

[@abrahamjabangwe2945]

thanks

[@lesgrossman834]

If you hear an Indian accent from the first seconds of the video, then you immediately understand that you will get answers to all your questions!

[@МатвейМанько-ь6ч]

Thanks from Russia!