postgres for spatial data

Hello,

    I want to use postgres as a spatial database manager.
    I'm looking for a graphical interface that can display the
geometric types like polygon,...

    I'm also looking for SQL extension in order to make
spatial queries (for example, a function that tells if a point
belongs to the interior of a polygon)


    Thanks for your help,

David
dgross@lri.fr