|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.97 2010/04/23 23:21:43 rhaas Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.98 2010/04/30 19:49:06 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -308,6 +308,16 @@ COPY <replaceable class="parameter">count</replaceable> |
308 | 308 | <replaceable class="parameter">viewname</replaceable>) TO ...</literal>. |
309 | 309 | </para> |
310 | 310 |
|
| 311 | + <para> |
| 312 | + <command>COPY</command> only deals with the specific table named; |
| 313 | + it does not copy data to or from child tables. Thus for example |
| 314 | + <literal>COPY <replaceable class="parameter">table</> TO</literal> |
| 315 | + shows the same data as <literal>SELECT * FROM ONLY <replaceable |
| 316 | + class="parameter">table</></literal>. But <literal>COPY |
| 317 | + (SELECT * FROM <replaceable class="parameter">table</>) TO ...</literal> |
| 318 | + can be used to dump all of the data in an inheritance hierarchy. |
| 319 | + </para> |
| 320 | + |
311 | 321 | <para> |
312 | 322 | You must have select privilege on the table |
313 | 323 | whose values are read by <command>COPY TO</command>, and |
|