Skip site navigation (1) Skip section navigation (2)

Re: COPY example for partial tables

From: David Fetter <david(at)fetter(dot)org>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: COPY example for partial tables
Date: 2005-10-13 21:26:55
Message-ID: 20051013212655.GC4489@fetter.org (view raw or flat)
Thread:
Lists: pgsql-docs
On Thu, Oct 13, 2005 at 12:08:51AM -0400, 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.

Good catch :)

Cheers,
D
-- 
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

In response to

pgsql-docs by date

Next:From: Dave PageDate: 2005-10-13 21:31:24
Subject: Re: [DOCS] Typo in README.dist-split
Previous:From: Bruce MomjianDate: 2005-10-13 21:08:04
Subject: Re: [DOCS] Typo in README.dist-split

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group