i need to know if i can make a view which get data from another schema or a link wich point to a table in another schema. thanks in advance ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq