I have a database, called DEVE, which has got two users in it. say one user is tom and the other is james.Tom has finished his development work and james has not yet been finished. we want to move the database objects owned by tom to production.How to do it. if i take dump of the comlete database , it is including the james objects also, which i don't want to do. If I take pg_dump with -t options,i.e tables options, what about the sequences , triggers and other objects owned by tom. Moreover, it is cumbersome to take pg_dump with -t option, as there are more than 100 tables owned by tom. So please help me how to move the development schema to production, based on owner Thanks in advance for any help.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
