moving user obejcts to production
| От | s.chava@wcom.com (Srinivasa Rao Chava) |
|---|---|
| Тема | moving user obejcts to production |
| Дата | |
| Msg-id | 66d229f1.0110020612.5c87e712@posting.google.com обсуждение |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: