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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
