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

Re: Feature: give pg_dump a WHERE clause expression

From: Davy Durham <pubaddr5(at)davyandbeth(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Feature: give pg_dump a WHERE clause expression
Date: 2008-06-02 04:10:29
Message-ID: 1212379830.24863.4.camel@ubuntu (view raw or flat)
Thread:
Lists: pgsql-patches
On Sun, 2008-06-01 at 22:19 -0400, Stephen Frost wrote:

> 
> or so.  I suppose it might be interesting to consider an 'insert-format'
> output for COPY, which pg_dump could possibly be refactored to use when
> requested.  It'd be nice if it was easier to have COPY support more
> formats but right now it's kind of a pain.


That sounds also reasonable to me.  It seems like a worthy format that
COPY could output.

And sure.. pg_dump could then be simplified a bit by using this.  Beyond
that, pg_dump would probably most easily let the user specify the very
keyword (or full COPY statement parameters) that COPY would use as
output format rather than implementing flags for everything COPY already
supports.  Perhaps support the existing -d/-D flags for backwards
compatibility.

This makes pg_dump more flexible AND COPY more flexible for use cases
like mine.



In response to

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2008-06-02 04:22:26
Subject: Re: Feature: give pg_dump a WHERE clause expression
Previous:From: Tom LaneDate: 2008-06-02 02:47:34
Subject: Re: Feature: give pg_dump a WHERE clause expression

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