Re: COPY example for partial tables - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: COPY example for partial tables
Date
Msg-id 200510131445.j9DEj9605226@candle.pha.pa.us
Whole thread Raw
In response to Re: COPY example for partial tables  (Neil Conway <neilc@samurai.com>)
List pgsql-docs
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-docs by date:

Previous
From: Neil Conway
Date:
Subject: Re: COPY example for partial tables
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [SQL] Update timestamp on update