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.

At 14:27 11.9.2000 , Trewern, Ben wrote:

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.

Any help would be appreciated.

Ben.