Normally it's done with self-relation. You need a table with "ID" and "PARENT_ID". PARENT_ID will contain null for
rootlevel and other row's ID for children. One warning: going through such tree could be slow. I don't know is there
anythingPostgreSQL specific that might help. I know that Oracle have a special tree command.<br /><br /> At 14:27
11.9.2000, Trewern, Ben wrote: <br /><br /><font size="2"><blockquote cite="cite" type="cite">Anybody know how to make
atree structure using related tables using Postgres. Something like a directory structure is what I'm aiming for. I'm
surethere is an easy way but I'm having probs.<br /></blockquote></font><br /> Any help would be appreciated. <br /><br
/><fontsize="2">Ben.</font><br />