Hi,
I have a postgresql database(DEPG) in development which contains three
user accounts(pldev,extranet,intranet) for different applications. One
application(pldev) has been finished development and the other two are
still in development stage. The finished application(pldev) which
contains several tables , functions, procedures and triggers need to
be moved to production, leaving the unfinished in development.
I createa database PGPROD in production box and trying to move only
the objects belonging to finished application(pldev).If I use pg_dump,
it is dumping full database.
I need to dump only the finished application account(pldev).
In oracle , we use export with owner= username option for exporting
the individual users objects. and import in production server into the
respective user's account,say pldev in production database.
How to do it in postgresql? and is there any way to do it?
Thanks
chava