On 28 Sep 2001, at 12:12, Srinivasa Rao Chava wrote: > Hi, > How to move the database from devleopment to production. > For example, the database is already in production and some of the > tables required modifications. First those modification were > implemented in develoment. The modified tables need to be moved to > production from development,not the complete database. So how to move > the selective tables in development database to production database. > Thanks chava
pg_dump -t <new_table> <dev_db> |psql <prod_db> Mark ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
