Re: Schema-qualified statements in pg_dump output

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Schema-qualified statements in pg_dump output
Date: 2008-07-07 14:53:26
Message-ID: D1C06067E6169A6E1AC3B499@imhotep.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On Montag, Juli 07, 2008 10:33:35 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> It seems like quite a useless change, since in general there will be
> other qualified references in the dump that can't safely be removed.
> IOW what you intend to do doesn't work anyway.

Hmm, If i want to restore just a bunch of tables into a different schema,
all i need to do is to change the dump's search_path then and i don't have
to bother with DDL statements having hardwired schema qualifications. So
this seems a straight forward simplification to me.

--
Thanks

Bernd

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2008-07-07 15:00:49 Re: [HACKERS] SSL configure patch
Previous Message Tom Lane 2008-07-07 14:51:03 Re: [PATCHES] WIP: executor_hook for pg_stat_statements