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

Re: COPY example for partial tables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: COPY example for partial tables
Date: 2005-10-12 14:55:17
Message-ID: 200510121455.j9CEtHt10423@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
David Fetter wrote:
> Folks,
> 
> Please find enclosed a patch (should work for 7.3 and up) that
> illustrates a workaround for using COPY on parts of tables using
> temporary tables.  It's helped me, and it seems popular via a very
> brief and un-scientific poll.

I have attached and applied a modified version of this patch.  I removed
the VACUUM (because this is just an example and does not need to be a
complete solution, e.g. pg_class bloat), and removed the 8.2 mention
because it seemed unnecessary.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-docs by date

Next:From: Jeff WilliamsDate: 2005-10-13 01:12:34
Subject: Update timestamp on update
Previous:From: Michael FuhrDate: 2005-10-12 05:17:09
Subject: Re: Commented, loadable databases as examples?

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