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.