Re: db partial dumping with pg_dump

Поиск
Список
Период
Сортировка
От Scott Shattuck
Тема Re: db partial dumping with pg_dump
Дата
Msg-id 1029292188.7491.3851.camel@idearat
обсуждение исходный текст
Ответ на Re: db partial dumping with pg_dump  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: db partial dumping with pg_dump
Список pgsql-hackers
On Tue, 2002-08-13 at 19:54, Christopher Kings-Lynne wrote:
> > I'm finding it hard to visualize situations where I'd want the extra
> > baggage of pg_dump for something like this.  If I want the schema at
> > all, I'll probably want it separate from the data so that I can hack
> > the schema conveniently --- so I'd want to do a "pg_dump -s -t table"
> > and then do the selective copying separately.
> 
> Tell you what I'd kill for:
> 
> pg_dump -t users_\* db > users.sql
> 
> Sort of thing.
> 
> Chris
> 

I'd kill for pg_restore --ignore-missing-objects --clean .... so I could
run refreshes against databases that are changing schemas rather than
having to constantly edit the output of -l.

I'd also kill for pg_restore --ignore-existing-objects .... so I could
run the darn thing against a database that's already got pl/pgsql
installed in template1 and the dump file wants to install it again etc.

ss


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org




В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: [COMMITTERS] pgsql-server/src backend/tcop/postgres.cbacke
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [PATCHES] SQL99 CONVERT() function