| From: | Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Added schema selection to pg_restore |
| Date: | 2004-08-19 13:32:32 |
| Message-ID: | 4124ABF0.6060003@trust-factory.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Since I needed this feature badly, I added the -n / --schema switch to
pg_restore. It restores the given schemaname only. It can be used in
conjunction with the -t and other switches to make the selection very
fine grained.
This patches works for me, but it could use more testing.
Please Cc me in the discussion, as I am not on these lists.
I used the current CVS tree at
:pserver:anoncvs(at)anoncvs(dot)postgresql(dot)org:/projects/cvsroot as a starting
point.
Sincerely,
--
Richard van den Berg, CISSP
Trust Factory B.V. | http://www.trust-factory.com/
Bazarstraat 44a | Phone: +31 70 3620684
NL-2518AK The Hague | Fax : +31 70 3603009
The Netherlands |
| Attachment | Content-Type | Size |
|---|---|---|
| pg_restore-schema.patch | text/plain | 4.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erwin Moller | 2004-08-19 13:38:07 | Re: listing triggers |
| Previous Message | ohp | 2004-08-19 12:51:28 | PITR question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-08-19 16:35:36 | Re: [BUGS] 8.0.0beta1: -lpthread missing |
| Previous Message | Gaetano Mendola | 2004-08-19 10:10:24 | Re: [HACKERS] 8.0 libpq: missing get_home_path() |