| From: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_restore and adding a column |
| Date: | 2003-03-21 04:51:22 |
| Message-ID: | Pine.NEB.4.44.0303202244560.23878-100000@ns01.minnesota.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
If I dump a DB out by first dumping out the schema only, then the entire
db like:
pg_dump --schema-only --file=mydb_schema.pgsql mydb
pg_dump --format=c --file=mydb.dump mydb
Then I add a column to the schema. If I now load the data back:
pg_restore --data-only -d mydb -f mydb.dump
pg_restore should handle that ok correct? In other words, it would only
restore the data to the appropriate column using column names and not just
the order of the columns.
--
Thomas T. Thai
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-03-21 05:09:00 | Re: Multiple backend connections |
| Previous Message | Shridhar Daithankar<shridhar_daithankar@persistent.co.in> | 2003-03-21 03:29:39 | Re: Extracting time from timestamp |