Re: [DOCS] COPY example for partial tables

2005-10-12 Thread Neil Conway
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

Re: [DOCS] [SQL] Update timestamp on update

2005-10-12 Thread Tom Lane
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

Re: [DOCS] COPY example for partial tables

2005-10-12 Thread Bruce Momjian
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