Skip site navigation (1) Skip section navigation (2)

Added schema selection to pg_restore

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: pg_restore-schema.patch
Description: text/plain (4.2 KB)

Responses

pgsql-hackers by date

Next:From: Erwin MollerDate: 2004-08-19 13:38:07
Subject: Re: listing triggers
Previous:From: ohpDate: 2004-08-19 12:51:28
Subject: PITR question

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-08-19 16:35:36
Subject: Re: [BUGS] 8.0.0beta1: -lpthread missing
Previous:From: Gaetano MendolaDate: 2004-08-19 10:10:24
Subject: Re: [HACKERS] 8.0 libpq: missing get_home_path()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group