hi what do you tink about : COPY [ namespace1. ] table [ STRUCT ONLY ] TO [namespace2.] table2; MOVE [ namepsace1. ] table TO [namespace2.] table2;
and this same whit types, functions etc and : ALERT FUNCTION func (ARGS) SET OWNER new_owner; and : CREATE TYPE new_type AS table; this can by replaced by LIKE : CREATE TYPE new_type AS ( LIKE table ) what i saw in one mail on this maillist can be ? bye iv ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org