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