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