On Wed, 2005-12-10 at 10:55 -0400, Bruce Momjian wrote:
>
> +To copy into a file just the countries whose names start with 'A'
> +using a temporary table which is automatically deleted:
> +
> +
> + BEGIN;
> + CREATE TEMP TABLE a_list_COUNTRIES AS
> + SELECT * FROM country WHERE
Jeff Williams <[EMAIL PROTECTED]> writes:
> Thanks. Triggers was my first thought, but chapter 35 on Triggers didn't
> really indicate a way I could do this easily and scared me with a lot of
> c code.
Yeah. This is a documentation issue that's bothered me for awhile.
The problem is that we treat
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 mod