hierarchical order equivalent - Mailing list pgsql-sql

Is there an equivalent way to do this Oracle query in Postgres?
Select category_id, parent_category_id, category_nameFROM CategorySTART WITH category_id = 6CONNECT BY PRIOR
category_id= parent_category_idOrder by category_name
 


I am trying to build a hierarchy of inter-related categories.  I want an
easy way to output the tree.  Any ideas?

Thanks,
Grant