[nmdrew53]

Hi folks
I have a small PostgreSQL db with a couple one-to-many relationships, but the “crowfoot” connector on the “many” side entity is not displaying in the ER diagram.
I believe that I have the foreign keys set correctly – the PK of “companies” (one) is set as a FK in “products” (many). Is the crowfoot supposed to display with a PostgreSQL db?

Any information will be appreciated.

thanks
Drew

[Brian Fernandes]

Drew,

They should display fine. If I understand you correctly, you can see a connection but the decorator at the end is incorrect?
Could you please paste the SQL for the two involved tables here? Also, can you see the FK in the FK column of the Table / Object Info view for the table in question?

[nmdrew53]

Hi Brian
thanks for your response. Fixed the problem by making sure the one-to-many relationships/foreign keys were correctly constructed in PostgreSQL tables.

appreciate your time

Drew

[Author]

Posts