Re: change existing table definition - Mailing list pgsql-admin

> pg_dump -c -t <table name> <database> > <dumpfile>
> psql <database> < <dumpfile>

I don't tested this but i think this works.

Be dangerous with the "-c" Option of dump ;). After
the dump was created, new data could be inserted into the
database. If you dump in the file, all dumped tables are
dropped. It's better to RENAME the existing table and then
COPY in the data.

greetings,

Martin


Am Dienstag, den 28.06.2005, 13:26 -0400 schrieb Chuming Chen:
> pgsql-admin@postgresql.org