<html>
Normally it's done with self-relation. You need a table with
"ID" and "PARENT_ID". PARENT_ID will contain null for
root level and other row's ID for children. One warning: going through
such tree could be slow. I don't know is there anything PostgreSQL
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 type=cite cite>Anybody know how to make a tree
structure using related tables using Postgres. Something like a
directory structure is what I'm aiming for. I'm sure there is an
easy way but I'm having probs.<br>
</font><br>
Any help would be appreciated. <br>
<br>
<font size=2>Ben.</font> </blockquote><br>
</html>