From 3d50e107ada773c7836ce494706b7557fac8be48 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Thu, 13 Oct 2005 02:00:09 +0000
Subject: Remove extra <para>

---
 doc/src/sgml/ref/copy.sgml | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index 34f1b496eb..5461924b36 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.67 2005/09/05 14:44:05 adunstan Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.68 2005/10/13 02:00:09 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -708,6 +708,18 @@ COPY country FROM '/usr1/proj/bray/sql/country_data';
 </programlisting>
   </para>
 
+  <para>
+   To copy into a file just the countries whose names start with 'A'
+   using a temporary table which is automatically deleted:
+<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>
+
   <para>
    Here is a sample of data suitable for copying into a table from
    <literal>STDIN</literal>:
-- 
cgit v1.2.3