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: (view raw, whole thread or download thread mbox)
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                        |
  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


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-2017 The PostgreSQL Global Development Group