I'm looking for a postgres-funtion that shows me the definition of a table. I found the -- pg_catalog.pg_get_viewdef(oid) -- pg_catalog.pg_get_constraintdef(oid) -- pg_catalog.pg_get_triggerdef(oid) -- pg_get_indexdef(oid) but I miss the same for a relation. Monika König ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster