Re: COPY example for partial tables

Neil Conway wrote:
> On Wed, 2005-12-10 at 10:55 -0400, Bruce Momjian wrote:
> > <para>
> > + To copy into a file just the countries whose names start with 'A'
> > + using a temporary table which is automatically deleted:
> > + </para>
> > + <programlisting>
> > + BEGIN;
> > + CREATE TEMP TABLE a_list_COUNTRIES AS
> > + SELECT * FROM country WHERE country_name LIKE 'A%';
> > + COPY a_list_countries TO '/usr1/proj/bray/sql/a_list_countries.copy';
> > + ROLLBACK;
> > + </programlisting>
> > + </para>
>
> The capitalization of "a_list_countries" is inconsistent -- both
> references should all be in lowercase, IMO.
>

Fixed. Thanks.

--
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