Re: Feature: give pg_dump a WHERE clause expression - Mailing list pgsql-patches

From Gregory Stark
Subject Re: Feature: give pg_dump a WHERE clause expression
Date
Msg-id 87r6bgvy4i.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Feature: give pg_dump a WHERE clause expression  (daveg <daveg@sonic.net>)
Responses Re: Feature: give pg_dump a WHERE clause expression  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
"daveg" <daveg@sonic.net> writes:

> The argument that one could just use copy and tar and gzip applies to the
> whole existance of pg_dump itself. pg_dump is just a more convenient way to
> copy out tables and as such does not NEED to exist at all. However it is
> convenient to that is does exist and does have convenient features to
> selectively handle schemas and tables.

That's not really true, pg_dump does a *lot* more work than just group table
data together. Its real value comes in reconstructing DDL for all the objects
and understanding the dependencies between them. That's functionality that
isn't available elsewhere and can't be reproduced without just reimplementing
pg_dump.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!

pgsql-patches by date:

Previous
From: Jan Urbański
Date:
Subject: Re: extend VacAttrStats to allow stavalues of different types
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: Map forks (WIP)