From: Neil Conway <neilc@samurai.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: David Fetter <david@fetter.org>
Cc: PostgreSQL Docs <pgsql-docs@postgresql.org>
Subject: Re: COPY example for partial tables
Date: Thu, 13 Oct 2005 00:08:51 -0400
Message-ID: <1129176531.8718.70.camel@localhost.localdomain> (raw)
In-Reply-To: <200510121455.j9CEtHt10423@candle.pha.pa.us>
References: <200510121455.j9CEtHt10423@candle.pha.pa.us>
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.
-Neil
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: neilc@samurai.com, pgman@candle.pha.pa.us, david@fetter.org
Subject: Re: COPY example for partial tables
In-Reply-To: <1129176531.8718.70.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox